DBA Data[Home] [Help]

APPS.AP_WORKFLOW_PKG dependencies on FND_MESSAGE

Line 152: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

148: EXCEPTION
149: WHEN OTHERS THEN
150: IF (SQLCODE <> -20001) THEN
151: rollback;
152: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
153: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
154: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
155: FND_MESSAGE.SET_TOKEN('PARAMETERS',
156: ' P_invoice_id = ' || p_invoice_id

Line 153: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

149: WHEN OTHERS THEN
150: IF (SQLCODE <> -20001) THEN
151: rollback;
152: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
153: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
154: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
155: FND_MESSAGE.SET_TOKEN('PARAMETERS',
156: ' P_invoice_id = ' || p_invoice_id
157: ||', P_calling_sequence = ' || l_curr_calling_sequence);

Line 154: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);

150: IF (SQLCODE <> -20001) THEN
151: rollback;
152: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
153: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
154: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
155: FND_MESSAGE.SET_TOKEN('PARAMETERS',
156: ' P_invoice_id = ' || p_invoice_id
157: ||', P_calling_sequence = ' || l_curr_calling_sequence);
158: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);

Line 155: FND_MESSAGE.SET_TOKEN('PARAMETERS',

151: rollback;
152: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
153: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
154: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
155: FND_MESSAGE.SET_TOKEN('PARAMETERS',
156: ' P_invoice_id = ' || p_invoice_id
157: ||', P_calling_sequence = ' || l_curr_calling_sequence);
158: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
159: END IF;

Line 158: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);

154: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
155: FND_MESSAGE.SET_TOKEN('PARAMETERS',
156: ' P_invoice_id = ' || p_invoice_id
157: ||', P_calling_sequence = ' || l_curr_calling_sequence);
158: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
159: END IF;
160:
161: APP_EXCEPTION.RAISE_EXCEPTION;
162:

Line 5820: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

5816:
5817: WHEN OTHERS
5818: THEN
5819: IF (SQLCODE <> -20001) THEN
5820: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
5821: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
5822: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_calling_sequence);
5823: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
5824: END IF;

Line 5821: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

5817: WHEN OTHERS
5818: THEN
5819: IF (SQLCODE <> -20001) THEN
5820: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
5821: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
5822: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_calling_sequence);
5823: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
5824: END IF;
5825: APP_EXCEPTION.RAISE_EXCEPTION;

Line 5822: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_calling_sequence);

5818: THEN
5819: IF (SQLCODE <> -20001) THEN
5820: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
5821: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
5822: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_calling_sequence);
5823: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
5824: END IF;
5825: APP_EXCEPTION.RAISE_EXCEPTION;
5826: END create_invapp_process;

Line 5823: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);

5819: IF (SQLCODE <> -20001) THEN
5820: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
5821: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
5822: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_calling_sequence);
5823: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
5824: END IF;
5825: APP_EXCEPTION.RAISE_EXCEPTION;
5826: END create_invapp_process;
5827:

Line 5985: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

5981: EXCEPTION
5982: WHEN OTHERS THEN
5983:
5984: IF (SQLCODE <> -20001) THEN
5985: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
5986: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
5987: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_calling_sequence);
5988: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
5989: END IF;

Line 5986: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

5982: WHEN OTHERS THEN
5983:
5984: IF (SQLCODE <> -20001) THEN
5985: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
5986: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
5987: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_calling_sequence);
5988: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
5989: END IF;
5990: APP_EXCEPTION.RAISE_EXCEPTION;

Line 5987: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_calling_sequence);

5983:
5984: IF (SQLCODE <> -20001) THEN
5985: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
5986: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
5987: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_calling_sequence);
5988: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
5989: END IF;
5990: APP_EXCEPTION.RAISE_EXCEPTION;
5991:

Line 5988: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);

5984: IF (SQLCODE <> -20001) THEN
5985: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
5986: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
5987: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_calling_sequence);
5988: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
5989: END IF;
5990: APP_EXCEPTION.RAISE_EXCEPTION;
5991:
5992: END Stop_Approval;

Line 6437: l_reason_flex := FND_MESSAGE.GET;

6433: 'SQLGL',
6434: 'GL#',
6435: l_chart_of_accounts_id);
6436: IF (NOT l_result) THEN
6437: l_reason_flex := FND_MESSAGE.GET;
6438: END IF;
6439:
6440: l_result := FND_FLEX_EXT.GET_SEGMENTS(
6441: 'SQLGL',

Line 6449: l_reason_flex := FND_MESSAGE.GET;

6445: l_num_segments,
6446: l_segments);
6447:
6448: IF (NOT l_result) THEN
6449: l_reason_flex := FND_MESSAGE.GET;
6450: END IF;
6451:
6452: l_result := FND_FLEX_APIS.GET_QUALIFIER_SEGNUM(
6453: 101,

Line 6459: l_reason_flex := FND_MESSAGE.GET;

6455: l_chart_of_accounts_id,
6456: p_seg_name,
6457: l_segment_num);
6458: IF (NOT l_result) THEN
6459: l_reason_flex := FND_MESSAGE.GET;
6460: END IF;
6461:
6462: l_seg_val := l_segments(l_segment_num);
6463:

Line 6808: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

6804: EXCEPTION
6805: WHEN NO_DATA_FOUND THEN
6806: NULL;
6807: WHEN OTHERS THEN
6808: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
6809: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
6810: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_calling_sequence);
6811: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
6812: APP_EXCEPTION.RAISE_EXCEPTION;

Line 6809: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

6805: WHEN NO_DATA_FOUND THEN
6806: NULL;
6807: WHEN OTHERS THEN
6808: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
6809: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
6810: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_calling_sequence);
6811: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
6812: APP_EXCEPTION.RAISE_EXCEPTION;
6813: END;

Line 6810: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_calling_sequence);

6806: NULL;
6807: WHEN OTHERS THEN
6808: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
6809: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
6810: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_calling_sequence);
6811: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
6812: APP_EXCEPTION.RAISE_EXCEPTION;
6813: END;
6814:

Line 6811: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);

6807: WHEN OTHERS THEN
6808: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
6809: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
6810: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_calling_sequence);
6811: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
6812: APP_EXCEPTION.RAISE_EXCEPTION;
6813: END;
6814:
6815: END IF;

Line 7024: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

7020: EXCEPTION
7021: WHEN OTHERS
7022: THEN
7023: IF (SQLCODE <> -20001) THEN
7024: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
7025: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
7026: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_calling_sequence);
7027: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
7028: END IF;

Line 7025: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

7021: WHEN OTHERS
7022: THEN
7023: IF (SQLCODE <> -20001) THEN
7024: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
7025: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
7026: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_calling_sequence);
7027: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
7028: END IF;
7029: APP_EXCEPTION.RAISE_EXCEPTION;

Line 7026: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_calling_sequence);

7022: THEN
7023: IF (SQLCODE <> -20001) THEN
7024: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
7025: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
7026: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_calling_sequence);
7027: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
7028: END IF;
7029: APP_EXCEPTION.RAISE_EXCEPTION;
7030:

Line 7027: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);

7023: IF (SQLCODE <> -20001) THEN
7024: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
7025: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
7026: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_calling_sequence);
7027: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
7028: END IF;
7029: APP_EXCEPTION.RAISE_EXCEPTION;
7030:
7031: END Get_All_Approvers;

Line 7125: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

7121: EXCEPTION
7122: WHEN OTHERS THEN
7123:
7124: IF (SQLCODE <> -20001) THEN
7125: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
7126: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
7127: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_calling_sequence);
7128: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
7129: END IF;

Line 7126: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

7122: WHEN OTHERS THEN
7123:
7124: IF (SQLCODE <> -20001) THEN
7125: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
7126: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
7127: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_calling_sequence);
7128: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
7129: END IF;
7130: APP_EXCEPTION.RAISE_EXCEPTION;

Line 7127: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_calling_sequence);

7123:
7124: IF (SQLCODE <> -20001) THEN
7125: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
7126: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
7127: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_calling_sequence);
7128: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
7129: END IF;
7130: APP_EXCEPTION.RAISE_EXCEPTION;
7131:

Line 7128: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);

7124: IF (SQLCODE <> -20001) THEN
7125: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
7126: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
7127: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', l_calling_sequence);
7128: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
7129: END IF;
7130: APP_EXCEPTION.RAISE_EXCEPTION;
7131:
7132: END Terminate_Approval;

Line 7833: FND_MESSAGE.Set_Name('SQLAP', 'AP_CARD_VERIFY_LOCK_FAILED');

7829:
7830: EXCEPTION
7831: WHEN OTHERS THEN
7832: l_debug_info := 'Invoice is in lock. Please try later';
7833: FND_MESSAGE.Set_Name('SQLAP', 'AP_CARD_VERIFY_LOCK_FAILED');
7834: l_error_message := FND_MESSAGE.Get;
7835: APP_EXCEPTION.RAISE_EXCEPTION;
7836: END;
7837: -- Bug 5037108 Ends

Line 7834: l_error_message := FND_MESSAGE.Get;

7830: EXCEPTION
7831: WHEN OTHERS THEN
7832: l_debug_info := 'Invoice is in lock. Please try later';
7833: FND_MESSAGE.Set_Name('SQLAP', 'AP_CARD_VERIFY_LOCK_FAILED');
7834: l_error_message := FND_MESSAGE.Get;
7835: APP_EXCEPTION.RAISE_EXCEPTION;
7836: END;
7837: -- Bug 5037108 Ends
7838:

Line 8204: FND_MESSAGE.Set_Name('SQLAP', 'AP_CARD_VERIFY_LOCK_FAILED');

8200:
8201: EXCEPTION
8202: WHEN OTHERS THEN
8203: l_debug_info := 'Invoice is in lock. Please try later';
8204: FND_MESSAGE.Set_Name('SQLAP', 'AP_CARD_VERIFY_LOCK_FAILED');
8205: l_error_message := FND_MESSAGE.Get;
8206: APP_EXCEPTION.RAISE_EXCEPTION;
8207: END;
8208: -- Bug 5037108 Ends

Line 8205: l_error_message := FND_MESSAGE.Get;

8201: EXCEPTION
8202: WHEN OTHERS THEN
8203: l_debug_info := 'Invoice is in lock. Please try later';
8204: FND_MESSAGE.Set_Name('SQLAP', 'AP_CARD_VERIFY_LOCK_FAILED');
8205: l_error_message := FND_MESSAGE.Get;
8206: APP_EXCEPTION.RAISE_EXCEPTION;
8207: END;
8208: -- Bug 5037108 Ends
8209: