DBA Data[Home] [Help]

APPS.OKS_CUSTOMER_ACCEPTANCE_PVT dependencies on FND_MESSAGE

Line 347: -- set the fnd message for acceptance clause

343: END IF;
344:
345: CLOSE csr_vendor_token_exists;
346:
347: -- set the fnd message for acceptance clause
348: fnd_message.set_name ('OKS', 'OKS_CUST_ACCEPT_CLAUSE');
349:
350: IF l_customer_token_exists = 'Y' THEN
351: fnd_message.set_token ('CUSTOMER_NAME', l_customer_name);

Line 348: fnd_message.set_name ('OKS', 'OKS_CUST_ACCEPT_CLAUSE');

344:
345: CLOSE csr_vendor_token_exists;
346:
347: -- set the fnd message for acceptance clause
348: fnd_message.set_name ('OKS', 'OKS_CUST_ACCEPT_CLAUSE');
349:
350: IF l_customer_token_exists = 'Y' THEN
351: fnd_message.set_token ('CUSTOMER_NAME', l_customer_name);
352: END IF;

Line 351: fnd_message.set_token ('CUSTOMER_NAME', l_customer_name);

347: -- set the fnd message for acceptance clause
348: fnd_message.set_name ('OKS', 'OKS_CUST_ACCEPT_CLAUSE');
349:
350: IF l_customer_token_exists = 'Y' THEN
351: fnd_message.set_token ('CUSTOMER_NAME', l_customer_name);
352: END IF;
353:
354: IF l_vendor_token_exists = 'Y' THEN
355: fnd_message.set_token ('VENDOR_NAME', l_vendor_name);

Line 355: fnd_message.set_token ('VENDOR_NAME', l_vendor_name);

351: fnd_message.set_token ('CUSTOMER_NAME', l_customer_name);
352: END IF;
353:
354: IF l_vendor_token_exists = 'Y' THEN
355: fnd_message.set_token ('VENDOR_NAME', l_vendor_name);
356: END IF;
357:
358: l_contract_accept_clause := fnd_message.get;
359:

Line 358: l_contract_accept_clause := fnd_message.get;

354: IF l_vendor_token_exists = 'Y' THEN
355: fnd_message.set_token ('VENDOR_NAME', l_vendor_name);
356: END IF;
357:
358: l_contract_accept_clause := fnd_message.get;
359:
360: -- end debug log
361: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
362: fnd_log.STRING (fnd_log.level_procedure,

Line 498: -- set the fnd message for decline clause

494: END IF;
495:
496: CLOSE csr_vendor_token_exists;
497:
498: -- set the fnd message for decline clause
499: fnd_message.set_name ('OKS', 'OKS_CUST_DECLINE_CLAUSE');
500:
501: IF l_customer_token_exists = 'Y' THEN
502: fnd_message.set_token ('CUSTOMER_NAME', l_customer_name);

Line 499: fnd_message.set_name ('OKS', 'OKS_CUST_DECLINE_CLAUSE');

495:
496: CLOSE csr_vendor_token_exists;
497:
498: -- set the fnd message for decline clause
499: fnd_message.set_name ('OKS', 'OKS_CUST_DECLINE_CLAUSE');
500:
501: IF l_customer_token_exists = 'Y' THEN
502: fnd_message.set_token ('CUSTOMER_NAME', l_customer_name);
503: END IF;

Line 502: fnd_message.set_token ('CUSTOMER_NAME', l_customer_name);

498: -- set the fnd message for decline clause
499: fnd_message.set_name ('OKS', 'OKS_CUST_DECLINE_CLAUSE');
500:
501: IF l_customer_token_exists = 'Y' THEN
502: fnd_message.set_token ('CUSTOMER_NAME', l_customer_name);
503: END IF;
504:
505: IF l_vendor_token_exists = 'Y' THEN
506: fnd_message.set_token ('VENDOR_NAME', l_vendor_name);

Line 506: fnd_message.set_token ('VENDOR_NAME', l_vendor_name);

502: fnd_message.set_token ('CUSTOMER_NAME', l_customer_name);
503: END IF;
504:
505: IF l_vendor_token_exists = 'Y' THEN
506: fnd_message.set_token ('VENDOR_NAME', l_vendor_name);
507: END IF;
508:
509: l_contract_decline_clause := fnd_message.get;
510:

Line 509: l_contract_decline_clause := fnd_message.get;

505: IF l_vendor_token_exists = 'Y' THEN
506: fnd_message.set_token ('VENDOR_NAME', l_vendor_name);
507: END IF;
508:
509: l_contract_decline_clause := fnd_message.get;
510:
511: -- end debug log
512: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
513: fnd_log.STRING (fnd_log.level_procedure,

Line 1128: -- set the fnd message for email subject

1124:
1125: CLOSE csr_k_number;
1126:
1127: -- build the email subject message
1128: -- set the fnd message for email subject
1129: fnd_message.set_name ('OKS', 'OKS_CUST_ACCEPT_EMAIL_SUB');
1130: fnd_message.set_token ('CONTRACT_NUM', l_contract_number);
1131: l_email_subject := fnd_message.get;
1132:

Line 1129: fnd_message.set_name ('OKS', 'OKS_CUST_ACCEPT_EMAIL_SUB');

1125: CLOSE csr_k_number;
1126:
1127: -- build the email subject message
1128: -- set the fnd message for email subject
1129: fnd_message.set_name ('OKS', 'OKS_CUST_ACCEPT_EMAIL_SUB');
1130: fnd_message.set_token ('CONTRACT_NUM', l_contract_number);
1131: l_email_subject := fnd_message.get;
1132:
1133: -- end debug log

Line 1130: fnd_message.set_token ('CONTRACT_NUM', l_contract_number);

1126:
1127: -- build the email subject message
1128: -- set the fnd message for email subject
1129: fnd_message.set_name ('OKS', 'OKS_CUST_ACCEPT_EMAIL_SUB');
1130: fnd_message.set_token ('CONTRACT_NUM', l_contract_number);
1131: l_email_subject := fnd_message.get;
1132:
1133: -- end debug log
1134: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

Line 1131: l_email_subject := fnd_message.get;

1127: -- build the email subject message
1128: -- set the fnd message for email subject
1129: fnd_message.set_name ('OKS', 'OKS_CUST_ACCEPT_EMAIL_SUB');
1130: fnd_message.set_token ('CONTRACT_NUM', l_contract_number);
1131: l_email_subject := fnd_message.get;
1132:
1133: -- end debug log
1134: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1135: fnd_log.STRING (fnd_log.level_procedure,

Line 2024: fnd_message.set_name (g_app_name, 'OKS_CC_INVALID_DATA');

2020: -- this is a new credit card, check if all info is entered from UI
2021: IF (p_card_number IS NULL)
2022: OR (p_expiration_month IS NULL)
2023: OR (p_expiration_year IS NULL) THEN
2024: fnd_message.set_name (g_app_name, 'OKS_CC_INVALID_DATA');
2025: fnd_msg_pub.ADD;
2026: RAISE fnd_api.g_exc_unexpected_error;
2027: END IF; -- cc info invalid
2028: END IF; -- p_instr_assignment_id is null

Line 3151: fnd_message.set_name (g_app_name, 'OKS_IBY_API_ERROR');

3147: );
3148: END IF;
3149:
3150: IF (x_return_status = g_ret_sts_unexp_error) THEN
3151: fnd_message.set_name (g_app_name, 'OKS_IBY_API_ERROR');
3152: fnd_message.set_token
3153: ('IBY_API_NAME',
3154: 'IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension');
3155: fnd_message.set_token ('ERROR_DTLS', l_response.result_message);

Line 3152: fnd_message.set_token

3148: END IF;
3149:
3150: IF (x_return_status = g_ret_sts_unexp_error) THEN
3151: fnd_message.set_name (g_app_name, 'OKS_IBY_API_ERROR');
3152: fnd_message.set_token
3153: ('IBY_API_NAME',
3154: 'IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension');
3155: fnd_message.set_token ('ERROR_DTLS', l_response.result_message);
3156: fnd_msg_pub.ADD;

Line 3155: fnd_message.set_token ('ERROR_DTLS', l_response.result_message);

3151: fnd_message.set_name (g_app_name, 'OKS_IBY_API_ERROR');
3152: fnd_message.set_token
3153: ('IBY_API_NAME',
3154: 'IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension');
3155: fnd_message.set_token ('ERROR_DTLS', l_response.result_message);
3156: fnd_msg_pub.ADD;
3157: RAISE fnd_api.g_exc_unexpected_error;
3158: ELSIF (x_return_status = g_ret_sts_error) THEN
3159: /*

Line 3166: fnd_message.set_name (g_app_name, 'OKS_IBY_API_ERROR');

3162: If QA check is run on the contract, then delete will fail and iby will return an error
3163: We will ignore Error from iby when delete txn is called.
3164:
3165:
3166: fnd_message.set_name (g_app_name, 'OKS_IBY_API_ERROR');
3167: fnd_message.set_token
3168: ('IBY_API_NAME',
3169: 'IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension');
3170: fnd_message.set_token ('ERROR_DTLS', l_response.result_message);

Line 3167: fnd_message.set_token

3163: We will ignore Error from iby when delete txn is called.
3164:
3165:
3166: fnd_message.set_name (g_app_name, 'OKS_IBY_API_ERROR');
3167: fnd_message.set_token
3168: ('IBY_API_NAME',
3169: 'IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension');
3170: fnd_message.set_token ('ERROR_DTLS', l_response.result_message);
3171: fnd_msg_pub.ADD;

Line 3170: fnd_message.set_token ('ERROR_DTLS', l_response.result_message);

3166: fnd_message.set_name (g_app_name, 'OKS_IBY_API_ERROR');
3167: fnd_message.set_token
3168: ('IBY_API_NAME',
3169: 'IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension');
3170: fnd_message.set_token ('ERROR_DTLS', l_response.result_message);
3171: fnd_msg_pub.ADD;
3172: RAISE fnd_api.g_exc_error;
3173: */
3174: null; -- error is ignored

Line 3325: fnd_message.set_name (g_app_name, 'OKS_IBY_API_ERROR');

3321: );
3322: END IF;
3323:
3324: IF (x_return_status = g_ret_sts_unexp_error) THEN
3325: fnd_message.set_name (g_app_name, 'OKS_IBY_API_ERROR');
3326: fnd_message.set_token ('IBY_API_NAME',
3327: 'IBY_FNDCPT_SETUP_PUB.Process_Credit_Card');
3328: fnd_message.set_token ('ERROR_DTLS', l_response.result_message);
3329: fnd_msg_pub.ADD;

Line 3326: fnd_message.set_token ('IBY_API_NAME',

3322: END IF;
3323:
3324: IF (x_return_status = g_ret_sts_unexp_error) THEN
3325: fnd_message.set_name (g_app_name, 'OKS_IBY_API_ERROR');
3326: fnd_message.set_token ('IBY_API_NAME',
3327: 'IBY_FNDCPT_SETUP_PUB.Process_Credit_Card');
3328: fnd_message.set_token ('ERROR_DTLS', l_response.result_message);
3329: fnd_msg_pub.ADD;
3330: RAISE fnd_api.g_exc_unexpected_error;

Line 3328: fnd_message.set_token ('ERROR_DTLS', l_response.result_message);

3324: IF (x_return_status = g_ret_sts_unexp_error) THEN
3325: fnd_message.set_name (g_app_name, 'OKS_IBY_API_ERROR');
3326: fnd_message.set_token ('IBY_API_NAME',
3327: 'IBY_FNDCPT_SETUP_PUB.Process_Credit_Card');
3328: fnd_message.set_token ('ERROR_DTLS', l_response.result_message);
3329: fnd_msg_pub.ADD;
3330: RAISE fnd_api.g_exc_unexpected_error;
3331: ELSIF (x_return_status = g_ret_sts_error) THEN
3332: fnd_message.set_name (g_app_name, 'OKS_IBY_API_ERROR');

Line 3332: fnd_message.set_name (g_app_name, 'OKS_IBY_API_ERROR');

3328: fnd_message.set_token ('ERROR_DTLS', l_response.result_message);
3329: fnd_msg_pub.ADD;
3330: RAISE fnd_api.g_exc_unexpected_error;
3331: ELSIF (x_return_status = g_ret_sts_error) THEN
3332: fnd_message.set_name (g_app_name, 'OKS_IBY_API_ERROR');
3333: fnd_message.set_token ('IBY_API_NAME',
3334: 'IBY_FNDCPT_SETUP_PUB.Process_Credit_Card');
3335: fnd_message.set_token ('ERROR_DTLS', l_response.result_message);
3336: fnd_msg_pub.ADD;

Line 3333: fnd_message.set_token ('IBY_API_NAME',

3329: fnd_msg_pub.ADD;
3330: RAISE fnd_api.g_exc_unexpected_error;
3331: ELSIF (x_return_status = g_ret_sts_error) THEN
3332: fnd_message.set_name (g_app_name, 'OKS_IBY_API_ERROR');
3333: fnd_message.set_token ('IBY_API_NAME',
3334: 'IBY_FNDCPT_SETUP_PUB.Process_Credit_Card');
3335: fnd_message.set_token ('ERROR_DTLS', l_response.result_message);
3336: fnd_msg_pub.ADD;
3337: RAISE fnd_api.g_exc_error;

Line 3335: fnd_message.set_token ('ERROR_DTLS', l_response.result_message);

3331: ELSIF (x_return_status = g_ret_sts_error) THEN
3332: fnd_message.set_name (g_app_name, 'OKS_IBY_API_ERROR');
3333: fnd_message.set_token ('IBY_API_NAME',
3334: 'IBY_FNDCPT_SETUP_PUB.Process_Credit_Card');
3335: fnd_message.set_token ('ERROR_DTLS', l_response.result_message);
3336: fnd_msg_pub.ADD;
3337: RAISE fnd_api.g_exc_error;
3338: END IF;
3339: ELSE

Line 3501: fnd_message.set_name (g_app_name, 'OKS_IBY_API_ERROR');

3497: );
3498: END IF;
3499:
3500: IF (x_return_status = g_ret_sts_unexp_error) THEN
3501: fnd_message.set_name (g_app_name, 'OKS_IBY_API_ERROR');
3502: fnd_message.set_token
3503: ('IBY_API_NAME',
3504: 'IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension');
3505: fnd_message.set_token ('ERROR_DTLS', l_response.result_message);

Line 3502: fnd_message.set_token

3498: END IF;
3499:
3500: IF (x_return_status = g_ret_sts_unexp_error) THEN
3501: fnd_message.set_name (g_app_name, 'OKS_IBY_API_ERROR');
3502: fnd_message.set_token
3503: ('IBY_API_NAME',
3504: 'IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension');
3505: fnd_message.set_token ('ERROR_DTLS', l_response.result_message);
3506: fnd_msg_pub.ADD;

Line 3505: fnd_message.set_token ('ERROR_DTLS', l_response.result_message);

3501: fnd_message.set_name (g_app_name, 'OKS_IBY_API_ERROR');
3502: fnd_message.set_token
3503: ('IBY_API_NAME',
3504: 'IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension');
3505: fnd_message.set_token ('ERROR_DTLS', l_response.result_message);
3506: fnd_msg_pub.ADD;
3507: RAISE fnd_api.g_exc_unexpected_error;
3508: ELSIF (x_return_status = g_ret_sts_error) THEN
3509: fnd_message.set_name (g_app_name, 'OKS_IBY_API_ERROR');

Line 3509: fnd_message.set_name (g_app_name, 'OKS_IBY_API_ERROR');

3505: fnd_message.set_token ('ERROR_DTLS', l_response.result_message);
3506: fnd_msg_pub.ADD;
3507: RAISE fnd_api.g_exc_unexpected_error;
3508: ELSIF (x_return_status = g_ret_sts_error) THEN
3509: fnd_message.set_name (g_app_name, 'OKS_IBY_API_ERROR');
3510: fnd_message.set_token
3511: ('IBY_API_NAME',
3512: 'IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension');
3513: fnd_message.set_token ('ERROR_DTLS', l_response.result_message);

Line 3510: fnd_message.set_token

3506: fnd_msg_pub.ADD;
3507: RAISE fnd_api.g_exc_unexpected_error;
3508: ELSIF (x_return_status = g_ret_sts_error) THEN
3509: fnd_message.set_name (g_app_name, 'OKS_IBY_API_ERROR');
3510: fnd_message.set_token
3511: ('IBY_API_NAME',
3512: 'IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension');
3513: fnd_message.set_token ('ERROR_DTLS', l_response.result_message);
3514: fnd_msg_pub.ADD;

Line 3513: fnd_message.set_token ('ERROR_DTLS', l_response.result_message);

3509: fnd_message.set_name (g_app_name, 'OKS_IBY_API_ERROR');
3510: fnd_message.set_token
3511: ('IBY_API_NAME',
3512: 'IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension');
3513: fnd_message.set_token ('ERROR_DTLS', l_response.result_message);
3514: fnd_msg_pub.ADD;
3515: RAISE fnd_api.g_exc_error;
3516: END IF;
3517:

Line 3976: fnd_message.set_name (g_app_name, 'OKS_IBY_API_ERROR');

3972: );
3973: END IF; -- debug log
3974:
3975: IF (x_return_status = g_ret_sts_unexp_error) THEN
3976: fnd_message.set_name (g_app_name, 'OKS_IBY_API_ERROR');
3977: fnd_message.set_token
3978: ('IBY_API_NAME',
3979: 'IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension');
3980: fnd_message.set_token ('ERROR_DTLS', l_response.result_message);

Line 3977: fnd_message.set_token

3973: END IF; -- debug log
3974:
3975: IF (x_return_status = g_ret_sts_unexp_error) THEN
3976: fnd_message.set_name (g_app_name, 'OKS_IBY_API_ERROR');
3977: fnd_message.set_token
3978: ('IBY_API_NAME',
3979: 'IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension');
3980: fnd_message.set_token ('ERROR_DTLS', l_response.result_message);
3981: fnd_msg_pub.ADD;

Line 3980: fnd_message.set_token ('ERROR_DTLS', l_response.result_message);

3976: fnd_message.set_name (g_app_name, 'OKS_IBY_API_ERROR');
3977: fnd_message.set_token
3978: ('IBY_API_NAME',
3979: 'IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension');
3980: fnd_message.set_token ('ERROR_DTLS', l_response.result_message);
3981: fnd_msg_pub.ADD;
3982: RAISE fnd_api.g_exc_unexpected_error;
3983: ELSIF (x_return_status = g_ret_sts_error) THEN
3984: /*

Line 3991: fnd_message.set_name (g_app_name, 'OKS_IBY_API_ERROR');

3987: In OKS QA check, we get a authorization from iby to validate credit card
3988: If QA check is run on the contract, then delete will fail and iby will return an error
3989: We will ignore Error from iby when delete txn is called.
3990:
3991: fnd_message.set_name (g_app_name, 'OKS_IBY_API_ERROR');
3992: fnd_message.set_token
3993: ('IBY_API_NAME',
3994: 'IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension');
3995: fnd_message.set_token ('ERROR_DTLS', l_response.result_message);

Line 3992: fnd_message.set_token

3988: If QA check is run on the contract, then delete will fail and iby will return an error
3989: We will ignore Error from iby when delete txn is called.
3990:
3991: fnd_message.set_name (g_app_name, 'OKS_IBY_API_ERROR');
3992: fnd_message.set_token
3993: ('IBY_API_NAME',
3994: 'IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension');
3995: fnd_message.set_token ('ERROR_DTLS', l_response.result_message);
3996: fnd_msg_pub.ADD;

Line 3995: fnd_message.set_token ('ERROR_DTLS', l_response.result_message);

3991: fnd_message.set_name (g_app_name, 'OKS_IBY_API_ERROR');
3992: fnd_message.set_token
3993: ('IBY_API_NAME',
3994: 'IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension');
3995: fnd_message.set_token ('ERROR_DTLS', l_response.result_message);
3996: fnd_msg_pub.ADD;
3997: RAISE fnd_api.g_exc_error;
3998: */
3999: x_return_status := fnd_api.g_ret_sts_success; -- initialize