eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKC_IMP_TERMS_TEMPLATES_PVT dependencies on FND_MSG_PUB

Line 125: FOR i IN 1 .. fnd_msg_pub.count_msg

121: PROCEDURE read_message (x_message IN OUT NOCOPY VARCHAR2)
122: IS
123: l_message VARCHAR2 (2000);
124: BEGIN
125: FOR i IN 1 .. fnd_msg_pub.count_msg
126: LOOP
127: l_message := fnd_msg_pub.get (i, p_encoded => fnd_api.g_false);
128:
129: IF (LENGTH (l_message) + LENGTH (NVL (x_message, ' '))) <= 2500

Line 127: l_message := fnd_msg_pub.get (i, p_encoded => fnd_api.g_false);

123: l_message VARCHAR2 (2000);
124: BEGIN
125: FOR i IN 1 .. fnd_msg_pub.count_msg
126: LOOP
127: l_message := fnd_msg_pub.get (i, p_encoded => fnd_api.g_false);
128:
129: IF (LENGTH (l_message) + LENGTH (NVL (x_message, ' '))) <= 2500
130: THEN
131: x_message := x_message || l_message;

Line 1191: fnd_msg_pub.initialize;

1187: END default_template;
1188: BEGIN
1189: -- Default Row
1190: default_template (p_template_rec => p_template_rec);
1191: fnd_msg_pub.initialize;
1192:
1193: -- Set the policy context
1194: IF p_template_rec.org_id IS NOT NULL
1195: THEN

Line 1908: fnd_msg_pub.initialize;

1904: set_rec_num_message (p_rec_num => l_failed_rec_num);
1905: read_message (l_error_message);
1906: p_template_tbl (i).errmsg := l_error_message;
1907: ROLLBACK TO create_template_sp;
1908: fnd_msg_pub.initialize;
1909: WHEN OTHERS
1910: THEN
1911: p_template_tbl (i).status := g_ret_sts_error;
1912: set_proc_error_message (p_proc => l_proc);

Line 1924: fnd_msg_pub.initialize;

1920: );
1921: read_message (l_error_message);
1922: p_template_tbl (i).errmsg := l_error_message;
1923: ROLLBACK TO create_template_sp;
1924: fnd_msg_pub.initialize;
1925: END;
1926: END LOOP;
1927: END IF;
1928: EXCEPTION

Line 1978: fnd_msg_pub.initialize;

1974: set_rec_num_message (p_rec_num => l_failed_rec_num);
1975: read_message (l_error_message);
1976: p_template_tbl (i).errmsg := l_error_message;
1977: ROLLBACK TO update_template_sp;
1978: fnd_msg_pub.initialize;
1979: WHEN OTHERS
1980: THEN
1981: p_template_tbl (i).status := g_ret_sts_error;
1982: set_proc_error_message (p_proc => l_proc);

Line 1994: fnd_msg_pub.initialize;

1990: );
1991: read_message (l_error_message);
1992: p_template_tbl (i).errmsg := l_error_message;
1993: ROLLBACK TO update_template_sp;
1994: fnd_msg_pub.initialize;
1995: END;
1996: END LOOP;
1997: END IF;
1998: EXCEPTION

Line 2361: fnd_msg_pub.initialize;

2357: RAISE;
2358: END validate_row;
2359: BEGIN
2360: SAVEPOINT create_section_sp;
2361: fnd_msg_pub.initialize;
2362:
2363: -- PRE - VALIDATION
2364: IF p_section_rec.document_id <> NVL (g_template_id, -1)
2365: THEN

Line 2397: fnd_msg_pub.initialize;

2393: -- Set Org Context
2394:
2395: -- Validate Row
2396: BEGIN
2397: fnd_msg_pub.initialize;
2398: validate_row (p_section_rec => p_section_rec);
2399: EXCEPTION
2400: WHEN OTHERS
2401: THEN

Line 2406: fnd_msg_pub.initialize;

2402: ROLLBACK TO create_section_sp;
2403: RAISE;
2404: END;
2405:
2406: fnd_msg_pub.initialize;
2407: -- Call to Insert Row
2408: okc_terms_sections_grp.create_section
2409: (p_api_version => 1,
2410: p_init_msg_list => fnd_api.g_true,

Line 2472: fnd_msg_pub.initialize;

2468: set_proc_error_message (p_proc => l_proc);
2469: read_message (l_error_message);
2470: p_section_rec.errmsg := l_error_message;
2471: ROLLBACK TO create_section_sp;
2472: fnd_msg_pub.initialize;
2473: WHEN OTHERS
2474: THEN
2475: p_section_rec.status := g_ret_sts_error;
2476: set_proc_error_message (p_proc => l_proc);

Line 2487: fnd_msg_pub.initialize;

2483: );
2484: read_message (l_error_message);
2485: p_section_rec.errmsg := l_error_message;
2486: ROLLBACK TO create_section_sp;
2487: fnd_msg_pub.initialize;
2488: END create_section;
2489:
2490: ---------------------------------------------------------------------------
2491: ---------------------------------------------------------------------------

Line 2939: fnd_msg_pub.initialize;

2935: END validate_row;
2936: ------------- SUB PROC END -----------------------------------------------
2937: BEGIN
2938: SAVEPOINT create_article_sp;
2939: fnd_msg_pub.initialize;
2940:
2941: IF p_article_rec.document_id <> NVL (g_template_id, -1)
2942: THEN
2943: IF inittemplateinfo (p_template_id => p_article_rec.document_id) <>

Line 2972: fnd_msg_pub.initialize;

2968: default_row (p_article_rec => p_article_rec);
2969:
2970: -- Validate Row
2971: BEGIN
2972: fnd_msg_pub.initialize;
2973: validate_row (p_article_rec => p_article_rec);
2974: EXCEPTION
2975: WHEN OTHERS
2976: THEN

Line 3078: fnd_msg_pub.initialize;

3074: set_proc_error_message (p_proc => l_proc);
3075: read_message (l_error_message);
3076: p_article_rec.errmsg := l_error_message;
3077: ROLLBACK TO create_article_sp;
3078: fnd_msg_pub.initialize;
3079: WHEN OTHERS
3080: THEN
3081: p_article_rec.status := g_ret_sts_error;
3082: set_proc_error_message (p_proc => l_proc);

Line 3093: fnd_msg_pub.initialize;

3089: );
3090: read_message (l_error_message);
3091: p_article_rec.errmsg := l_error_message;
3092: ROLLBACK TO create_article_sp;
3093: fnd_msg_pub.initialize;
3094: END create_article;
3095:
3096: PROCEDURE create_section (
3097: p_section_tbl IN OUT NOCOPY section_tbl_type,

Line 3132: fnd_msg_pub.initialize;

3128: )
3129: IS
3130: l_proc VARCHAR2 (120) := 'CREATE_TEMPLATE_REVISION';
3131: BEGIN
3132: fnd_msg_pub.initialize;
3133:
3134: -- PRE-VALIDATION
3135: IF inittemplateinfo (p_template_id => p_template_id) <> 'Y'
3136: THEN

Line 3173: fnd_msg_pub.initialize;

3169: THEN
3170: x_return_status := g_ret_sts_error;
3171: set_proc_error_message (p_proc => l_proc);
3172: read_message (x_msg_data);
3173: fnd_msg_pub.initialize;
3174: WHEN OTHERS
3175: THEN
3176: x_return_status := g_ret_sts_error;
3177: set_proc_error_message (p_proc => l_proc);

Line 3186: fnd_msg_pub.initialize;

3182: p_token2 => g_sqlerrm_token,
3183: p_token2_value => SQLERRM
3184: );
3185: read_message (x_msg_data);
3186: fnd_msg_pub.initialize;
3187: END create_template_revision;
3188:
3189: PROCEDURE delete_articles (
3190: p_template_id IN NUMBER,

Line 3200: fnd_msg_pub.initialize;

3196: )
3197: IS
3198: l_proc VARCHAR2 (60) := 'DELETE_ARTICLES';
3199: BEGIN
3200: fnd_msg_pub.initialize;
3201:
3202: IF p_template_id <> NVL (g_template_id, -1)
3203: THEN
3204: IF inittemplateinfo (p_template_id => p_template_id) <> 'Y'

Line 3254: fnd_msg_pub.initialize;

3250: THEN
3251: COMMIT;
3252: END IF;
3253:
3254: fnd_msg_pub.initialize;
3255: WHEN OTHERS
3256: THEN
3257: x_return_status := g_ret_sts_error;
3258: set_proc_error_message (p_proc => l_proc);

Line 3273: fnd_msg_pub.initialize;

3269: THEN
3270: COMMIT;
3271: END IF;
3272:
3273: fnd_msg_pub.initialize;
3274: END delete_articles;
3275:
3276: PROCEDURE delete_sections (
3277: p_template_id IN NUMBER,

Line 3288: fnd_msg_pub.initialize;

3284: IS
3285: --l_k_article_id_tbl k_article_id_tbl_type
3286: l_proc VARCHAR2 (60) := 'DELETE_SECTIONS';
3287: BEGIN
3288: fnd_msg_pub.initialize;
3289:
3290: IF p_template_id <> NVL (g_template_id, -1)
3291: THEN
3292: IF inittemplateinfo (p_template_id => p_template_id) <> 'Y'

Line 3347: fnd_msg_pub.initialize;

3343: THEN
3344: COMMIT;
3345: END IF;
3346:
3347: fnd_msg_pub.initialize;
3348: WHEN OTHERS
3349: THEN
3350: x_return_status := g_ret_sts_error;
3351: set_proc_error_message (p_proc => l_proc);

Line 3366: fnd_msg_pub.initialize;

3362: THEN
3363: COMMIT;
3364: END IF;
3365:
3366: fnd_msg_pub.initialize;
3367: END delete_sections;
3368:
3369: /**
3370: * Copy the p_deliverable_rec.deliverable_id to p_deliverable_rec.original_deliverable_id

Line 4626: fnd_msg_pub.initialize;

4622: RAISE;
4623: END validate_row;
4624: BEGIN
4625: SAVEPOINT create_deliverable_sp;
4626: fnd_msg_pub.initialize;
4627:
4628: IF p_deliverable_rec.business_document_id <> NVL (g_template_id, -1)
4629: THEN
4630: IF inittemplateinfo

Line 4668: fnd_msg_pub.initialize;

4664:
4665: default_row (p_deliverable_rec => p_deliverable_rec);
4666:
4667: BEGIN
4668: fnd_msg_pub.initialize;
4669: validate_row (p_deliverable_rec => p_deliverable_rec);
4670: EXCEPTION
4671: WHEN OTHERS
4672: THEN

Line 4921: fnd_msg_pub.initialize;

4917: set_proc_error_message (p_proc => l_proc);
4918: read_message (l_error_message);
4919: p_deliverable_rec.errmsg := l_error_message;
4920: ROLLBACK TO create_deliverable_sp;
4921: fnd_msg_pub.initialize;
4922: WHEN OTHERS
4923: THEN
4924: p_deliverable_rec.status := g_ret_sts_error;
4925: set_proc_error_message (p_proc => l_proc);

Line 4936: fnd_msg_pub.initialize;

4932: );
4933: read_message (l_error_message);
4934: p_deliverable_rec.errmsg := l_error_message;
4935: ROLLBACK TO create_deliverable_sp;
4936: fnd_msg_pub.initialize;
4937: END create_deliverable;
4938:
4939: PROCEDURE create_deliverable (
4940: p_deliverable_tbl IN OUT NOCOPY deliverable_tbl_type,

Line 4978: fnd_msg_pub.initialize;

4974: IS
4975: --l_k_article_id_tbl k_article_id_tbl_type
4976: l_proc VARCHAR2 (60) := 'DELETE_DELIVERABLES';
4977: BEGIN
4978: fnd_msg_pub.initialize;
4979:
4980: IF p_template_id <> NVL (g_template_id, -1)
4981: THEN
4982: IF inittemplateinfo (p_template_id => p_template_id) <> 'Y'

Line 5031: fnd_msg_pub.initialize;

5027: THEN
5028: COMMIT;
5029: END IF;
5030:
5031: fnd_msg_pub.initialize;
5032: WHEN OTHERS
5033: THEN
5034: x_return_status := g_ret_sts_error;
5035: set_proc_error_message (p_proc => l_proc);

Line 5050: fnd_msg_pub.initialize;

5046: THEN
5047: COMMIT;
5048: END IF;
5049:
5050: fnd_msg_pub.initialize;
5051: END delete_deliverables;
5052:
5053: PROCEDURE validate_tmpl_usage (
5054: p_template_id IN NUMBER,

Line 5388: fnd_msg_pub.initialize;

5384: THEN
5385: FOR i IN p_tmpl_usage_tbl.FIRST .. p_tmpl_usage_tbl.LAST
5386: LOOP
5387: BEGIN
5388: fnd_msg_pub.initialize;
5389: SAVEPOINT create_tmpl_usage_sp;
5390: create_tmpl_usage (p_template_id => p_template_id,
5391: p_tmpl_usage_rec => p_tmpl_usage_tbl
5392: (i)

Line 5407: fnd_msg_pub.initialize;

5403: p_tmpl_usage_tbl (i).status := g_ret_sts_error;
5404: read_message (l_error_message);
5405: p_tmpl_usage_tbl (i).errmsg := l_error_message;
5406: ROLLBACK TO create_tmpl_usage_sp;
5407: fnd_msg_pub.initialize;
5408: WHEN OTHERS
5409: THEN
5410: p_tmpl_usage_tbl (i).status := g_ret_sts_error;
5411: okc_api.set_message (p_app_name => g_app_name,

Line 5421: fnd_msg_pub.initialize;

5417: );
5418: read_message (l_error_message);
5419: p_tmpl_usage_tbl (i).errmsg := l_error_message;
5420: ROLLBACK TO create_tmpl_usage_sp;
5421: fnd_msg_pub.initialize;
5422: END;
5423: END LOOP;
5424: END IF;
5425: EXCEPTION

Line 5500: fnd_msg_pub.initialize;

5496: THEN
5497: FOR i IN p_tmpl_usage_tbl.FIRST .. p_tmpl_usage_tbl.LAST
5498: LOOP
5499: BEGIN
5500: fnd_msg_pub.initialize;
5501: SAVEPOINT update_tmpl_usage_sp;
5502: update_tmpl_usage (p_template_id => p_template_id,
5503: p_tmpl_usage_rec => p_tmpl_usage_tbl
5504: (i)

Line 5519: fnd_msg_pub.initialize;

5515: p_tmpl_usage_tbl (i).status := g_ret_sts_error;
5516: read_message (l_error_message);
5517: p_tmpl_usage_tbl (i).errmsg := l_error_message;
5518: ROLLBACK TO update_tmpl_usage_sp;
5519: fnd_msg_pub.initialize;
5520: WHEN OTHERS
5521: THEN
5522: p_tmpl_usage_tbl (i).status := g_ret_sts_error;
5523: okc_api.set_message (p_app_name => g_app_name,

Line 5533: fnd_msg_pub.initialize;

5529: );
5530: read_message (l_error_message);
5531: p_tmpl_usage_tbl (i).errmsg := l_error_message;
5532: ROLLBACK TO create_tmpl_usage_sp;
5533: fnd_msg_pub.initialize;
5534: END;
5535: END LOOP;
5536: END IF;
5537: EXCEPTION

Line 5592: fnd_msg_pub.initialize;

5588: THEN
5589: FOR i IN p_tmpl_usage_tbl.FIRST .. p_tmpl_usage_tbl.LAST
5590: LOOP
5591: BEGIN
5592: fnd_msg_pub.initialize;
5593: SAVEPOINT delete_tmpl_usage_sp;
5594: delete_tmpl_usage (p_template_id => p_template_id,
5595: p_tmpl_usage_rec => p_tmpl_usage_tbl
5596: (i)

Line 5611: fnd_msg_pub.initialize;

5607: p_tmpl_usage_tbl (i).status := g_ret_sts_error;
5608: read_message (l_error_message);
5609: p_tmpl_usage_tbl (i).errmsg := l_error_message;
5610: ROLLBACK TO delete_tmpl_usage_sp;
5611: fnd_msg_pub.initialize;
5612: WHEN OTHERS
5613: THEN
5614: p_tmpl_usage_tbl (i).status := g_ret_sts_error;
5615: okc_api.set_message (p_app_name => g_app_name,

Line 5625: fnd_msg_pub.initialize;

5621: );
5622: read_message (l_error_message);
5623: p_tmpl_usage_tbl (i).errmsg := l_error_message;
5624: ROLLBACK TO delete_tmpl_usage_sp;
5625: fnd_msg_pub.initialize;
5626: END;
5627: END LOOP;
5628: END IF;
5629: EXCEPTION