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.IBE_WORKFLOW_PVT dependencies on FND_MESSAGE

Line 762: -- Retrieve the message text for retrieve message from fnd_messages

758:
759: IF ((p_notif_context = 'SHARECARTNOTIF') OR
760: (p_notif_context = 'SHAREQUOTENOTIF'))THEN
761:
762: -- Retrieve the message text for retrieve message from fnd_messages
763: --fnd_message.set_name('IBE','IBE_PRMT_SC_RETRIEVE');
764: l_temp_retrieve_str := 'IBE_PRMT_SC_RETRIEVE';
765: --l_temp_retrieve_str := fnd_message.get;
766:

Line 763: --fnd_message.set_name('IBE','IBE_PRMT_SC_RETRIEVE');

759: IF ((p_notif_context = 'SHARECARTNOTIF') OR
760: (p_notif_context = 'SHAREQUOTENOTIF'))THEN
761:
762: -- Retrieve the message text for retrieve message from fnd_messages
763: --fnd_message.set_name('IBE','IBE_PRMT_SC_RETRIEVE');
764: l_temp_retrieve_str := 'IBE_PRMT_SC_RETRIEVE';
765: --l_temp_retrieve_str := fnd_message.get;
766:
767: wf_engine.SetItemAttrText(

Line 765: --l_temp_retrieve_str := fnd_message.get;

761:
762: -- Retrieve the message text for retrieve message from fnd_messages
763: --fnd_message.set_name('IBE','IBE_PRMT_SC_RETRIEVE');
764: l_temp_retrieve_str := 'IBE_PRMT_SC_RETRIEVE';
765: --l_temp_retrieve_str := fnd_message.get;
766:
767: wf_engine.SetItemAttrText(
768: itemtype => g_ItemType,
769: itemkey => p_item_key,

Line 1195: FND_MESSAGE.set_name('IBE',document_id);

1191: BEGIN
1192: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1193: IBE_UTIL.DEBUG(L_api_name||':START: value of document id ='||document_id);
1194: END IF;
1195: FND_MESSAGE.set_name('IBE',document_id);
1196: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1197: IBE_UTIL.DEBUG(L_api_name||':After call to FND_MESSAGE.set_name()');
1198: END IF;
1199: document:=FND_MESSAGE.get();

Line 1197: IBE_UTIL.DEBUG(L_api_name||':After call to FND_MESSAGE.set_name()');

1193: IBE_UTIL.DEBUG(L_api_name||':START: value of document id ='||document_id);
1194: END IF;
1195: FND_MESSAGE.set_name('IBE',document_id);
1196: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1197: IBE_UTIL.DEBUG(L_api_name||':After call to FND_MESSAGE.set_name()');
1198: END IF;
1199: document:=FND_MESSAGE.get();
1200: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1201: IBE_UTIL.DEBUG(L_api_name||'After Fnd_message.get(): document='||document);

Line 1199: document:=FND_MESSAGE.get();

1195: FND_MESSAGE.set_name('IBE',document_id);
1196: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1197: IBE_UTIL.DEBUG(L_api_name||':After call to FND_MESSAGE.set_name()');
1198: END IF;
1199: document:=FND_MESSAGE.get();
1200: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1201: IBE_UTIL.DEBUG(L_api_name||'After Fnd_message.get(): document='||document);
1202: END IF;
1203: document_type := 'text/plain';

Line 1201: IBE_UTIL.DEBUG(L_api_name||'After Fnd_message.get(): document='||document);

1197: IBE_UTIL.DEBUG(L_api_name||':After call to FND_MESSAGE.set_name()');
1198: END IF;
1199: document:=FND_MESSAGE.get();
1200: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1201: IBE_UTIL.DEBUG(L_api_name||'After Fnd_message.get(): document='||document);
1202: END IF;
1203: document_type := 'text/plain';
1204: EXCEPTION
1205: WHEN OTHERS THEN

Line 1242: --FND_MESSAGE.set_name('IBE','IBE_UM_WF_USER_CREDENTIALS');

1238: document := ' ';
1239:
1240: IF l_passwd is not null THEN
1241:
1242: --FND_MESSAGE.set_name('IBE','IBE_UM_WF_USER_CREDENTIALS');
1243: -- FND_MESSAGE.Set_Token('LOGINNAME', l_uname);
1244: FND_MESSAGE.set_name('IBE','IBE_UM_WF_USER_CREDENTIAL_PWD');
1245: FND_MESSAGE.Set_Token('PASSWORD', l_passwd);
1246: l_credential_line := ' ' || FND_MESSAGE.get();

Line 1243: -- FND_MESSAGE.Set_Token('LOGINNAME', l_uname);

1239:
1240: IF l_passwd is not null THEN
1241:
1242: --FND_MESSAGE.set_name('IBE','IBE_UM_WF_USER_CREDENTIALS');
1243: -- FND_MESSAGE.Set_Token('LOGINNAME', l_uname);
1244: FND_MESSAGE.set_name('IBE','IBE_UM_WF_USER_CREDENTIAL_PWD');
1245: FND_MESSAGE.Set_Token('PASSWORD', l_passwd);
1246: l_credential_line := ' ' || FND_MESSAGE.get();
1247: ELSE

Line 1244: FND_MESSAGE.set_name('IBE','IBE_UM_WF_USER_CREDENTIAL_PWD');

1240: IF l_passwd is not null THEN
1241:
1242: --FND_MESSAGE.set_name('IBE','IBE_UM_WF_USER_CREDENTIALS');
1243: -- FND_MESSAGE.Set_Token('LOGINNAME', l_uname);
1244: FND_MESSAGE.set_name('IBE','IBE_UM_WF_USER_CREDENTIAL_PWD');
1245: FND_MESSAGE.Set_Token('PASSWORD', l_passwd);
1246: l_credential_line := ' ' || FND_MESSAGE.get();
1247: ELSE
1248: l_credential_line := ' ';

Line 1245: FND_MESSAGE.Set_Token('PASSWORD', l_passwd);

1241:
1242: --FND_MESSAGE.set_name('IBE','IBE_UM_WF_USER_CREDENTIALS');
1243: -- FND_MESSAGE.Set_Token('LOGINNAME', l_uname);
1244: FND_MESSAGE.set_name('IBE','IBE_UM_WF_USER_CREDENTIAL_PWD');
1245: FND_MESSAGE.Set_Token('PASSWORD', l_passwd);
1246: l_credential_line := ' ' || FND_MESSAGE.get();
1247: ELSE
1248: l_credential_line := ' ';
1249:

Line 1246: l_credential_line := ' ' || FND_MESSAGE.get();

1242: --FND_MESSAGE.set_name('IBE','IBE_UM_WF_USER_CREDENTIALS');
1243: -- FND_MESSAGE.Set_Token('LOGINNAME', l_uname);
1244: FND_MESSAGE.set_name('IBE','IBE_UM_WF_USER_CREDENTIAL_PWD');
1245: FND_MESSAGE.Set_Token('PASSWORD', l_passwd);
1246: l_credential_line := ' ' || FND_MESSAGE.get();
1247: ELSE
1248: l_credential_line := ' ';
1249:
1250: END IF;

Line 1434: ibe_util.debug('NotifyRegistration:l_approval_msg =: '||fnd_message.get(l_approval_msg_name));

1430: ELSIF (l_UserType='IBE_PARTNER_PRIMARY') OR (l_UserType='IBE_PARTNER_BUSINESS') THEN
1431: l_approval_msg_name:='IBE_APPRVL_REQD_PRM';
1432: ELSE
1433: l_approval_msg_name:= l_UserType||'_APPR';
1434: ibe_util.debug('NotifyRegistration:l_approval_msg =: '||fnd_message.get(l_approval_msg_name));
1435: If fnd_message.get(l_approval_msg_name)= l_approval_msg_name Then
1436: l_approval_msg_name:='IBE_APPRVL_REQD_CUST';
1437: End if;
1438: END IF;

Line 1435: If fnd_message.get(l_approval_msg_name)= l_approval_msg_name Then

1431: l_approval_msg_name:='IBE_APPRVL_REQD_PRM';
1432: ELSE
1433: l_approval_msg_name:= l_UserType||'_APPR';
1434: ibe_util.debug('NotifyRegistration:l_approval_msg =: '||fnd_message.get(l_approval_msg_name));
1435: If fnd_message.get(l_approval_msg_name)= l_approval_msg_name Then
1436: l_approval_msg_name:='IBE_APPRVL_REQD_CUST';
1437: End if;
1438: END IF;
1439: ELSE --approval not associated with the user type

Line 1449: ibe_util.debug('NotifyRegistration:l_approval_msg =: '||fnd_message.get(l_approval_msg_name));

1445: ELSIF (l_UserType='IBE_PARTNER_PRIMARY') OR (l_UserType='IBE_PARTNER_BUSINESS') THEN
1446: l_approval_msg_name:='IBE_APPRVL_NOT_REQD_PRM';
1447: ELSE
1448: l_approval_msg_name:= l_UserType||'_NOAPPR';
1449: ibe_util.debug('NotifyRegistration:l_approval_msg =: '||fnd_message.get(l_approval_msg_name));
1450: If fnd_message.get(l_approval_msg_name)= l_approval_msg_name Then
1451: l_approval_msg_name:='IBE_APPRVL_NOT_REQD_CUST';
1452: End if;
1453: END IF;

Line 1450: If fnd_message.get(l_approval_msg_name)= l_approval_msg_name Then

1446: l_approval_msg_name:='IBE_APPRVL_NOT_REQD_PRM';
1447: ELSE
1448: l_approval_msg_name:= l_UserType||'_NOAPPR';
1449: ibe_util.debug('NotifyRegistration:l_approval_msg =: '||fnd_message.get(l_approval_msg_name));
1450: If fnd_message.get(l_approval_msg_name)= l_approval_msg_name Then
1451: l_approval_msg_name:='IBE_APPRVL_NOT_REQD_CUST';
1452: End if;
1453: END IF;
1454: END IF;

Line 5240: -- Retrieve the message text for update message from fnd_messages

5236: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
5237: IBE_UTIL.DEBUG('Notify_shared_cart:retrieving message mapping');
5238: END IF;
5239:
5240: -- Retrieve the message text for update message from fnd_messages
5241:
5242: IBE_WF_MSG_MAPPING_PVT.Retrieve_Msg_Mapping
5243: (
5244: p_org_id => l_OrgId,

Line 5504: -- Retrieve the message text for update message from fnd_messages

5500: IBE_UTIL.DEBUG('Notify_access_change:After message mapping call:l_MessageName: '||l_MessageName);
5501: IBE_UTIL.DEBUG('Notify_access_change:l_msgEnabled: '||l_msgEnabled);
5502: END IF;
5503:
5504: -- Retrieve the message text for update message from fnd_messages
5505: fnd_message.set_name('IBE','IBE_PRMT_UPDATE_CART');
5506: l_temp_update_str := FND_API.G_MISS_CHAR;
5507: l_temp_update_str := fnd_message.get;
5508: --l_msgEnabled := 'Y';

Line 5505: fnd_message.set_name('IBE','IBE_PRMT_UPDATE_CART');

5501: IBE_UTIL.DEBUG('Notify_access_change:l_msgEnabled: '||l_msgEnabled);
5502: END IF;
5503:
5504: -- Retrieve the message text for update message from fnd_messages
5505: fnd_message.set_name('IBE','IBE_PRMT_UPDATE_CART');
5506: l_temp_update_str := FND_API.G_MISS_CHAR;
5507: l_temp_update_str := fnd_message.get;
5508: --l_msgEnabled := 'Y';
5509: IF l_msgEnabled = 'Y' THEN

Line 5507: l_temp_update_str := fnd_message.get;

5503:
5504: -- Retrieve the message text for update message from fnd_messages
5505: fnd_message.set_name('IBE','IBE_PRMT_UPDATE_CART');
5506: l_temp_update_str := FND_API.G_MISS_CHAR;
5507: l_temp_update_str := fnd_message.get;
5508: --l_msgEnabled := 'Y';
5509: IF l_msgEnabled = 'Y' THEN
5510: l_url := p_url;
5511: l_url := l_url||p_quote_access_rec.quote_sharee_number;

Line 6346: fnd_message.set_name('IBE','IBE_PRMT_ORDER_NO_COLON');

6342: END IF;
6343:
6344: IF ( l_event_type = 'ORDFAX' OR l_event_type = 'ORDCONF' OR l_event_type = 'CNCLORDR' OR l_event_type = 'RETURNORDER') THEN
6345: -- IF (display_type = 'text/plain' ) THEN
6346: fnd_message.set_name('IBE','IBE_PRMT_ORDER_NO_COLON');
6347: l_temp_str := null;
6348: l_temp_str := fnd_message.get;
6349: l_document := l_document || l_temp_str ||TAB||TAB||TAB||g_header_rec.order_number||NEWLINE;
6350: fnd_message.set_name('IBE','IBE_PRMT_ORDER_DATE_COLON');

Line 6348: l_temp_str := fnd_message.get;

6344: IF ( l_event_type = 'ORDFAX' OR l_event_type = 'ORDCONF' OR l_event_type = 'CNCLORDR' OR l_event_type = 'RETURNORDER') THEN
6345: -- IF (display_type = 'text/plain' ) THEN
6346: fnd_message.set_name('IBE','IBE_PRMT_ORDER_NO_COLON');
6347: l_temp_str := null;
6348: l_temp_str := fnd_message.get;
6349: l_document := l_document || l_temp_str ||TAB||TAB||TAB||g_header_rec.order_number||NEWLINE;
6350: fnd_message.set_name('IBE','IBE_PRMT_ORDER_DATE_COLON');
6351: l_temp_str := null;
6352: l_temp_str := fnd_message.get;

Line 6350: fnd_message.set_name('IBE','IBE_PRMT_ORDER_DATE_COLON');

6346: fnd_message.set_name('IBE','IBE_PRMT_ORDER_NO_COLON');
6347: l_temp_str := null;
6348: l_temp_str := fnd_message.get;
6349: l_document := l_document || l_temp_str ||TAB||TAB||TAB||g_header_rec.order_number||NEWLINE;
6350: fnd_message.set_name('IBE','IBE_PRMT_ORDER_DATE_COLON');
6351: l_temp_str := null;
6352: l_temp_str := fnd_message.get;
6353: l_document := l_document || l_temp_str ||TAB||TAB||TAB||g_header_rec.ordered_date||NEWLINE;
6354: IF l_event_type <> 'RETURNORDER' THEN

Line 6352: l_temp_str := fnd_message.get;

6348: l_temp_str := fnd_message.get;
6349: l_document := l_document || l_temp_str ||TAB||TAB||TAB||g_header_rec.order_number||NEWLINE;
6350: fnd_message.set_name('IBE','IBE_PRMT_ORDER_DATE_COLON');
6351: l_temp_str := null;
6352: l_temp_str := fnd_message.get;
6353: l_document := l_document || l_temp_str ||TAB||TAB||TAB||g_header_rec.ordered_date||NEWLINE;
6354: IF l_event_type <> 'RETURNORDER' THEN
6355: fnd_message.set_name('IBE','IBE_PRMT_SHIP_METH_COLON');
6356: l_temp_str := null;

Line 6355: fnd_message.set_name('IBE','IBE_PRMT_SHIP_METH_COLON');

6351: l_temp_str := null;
6352: l_temp_str := fnd_message.get;
6353: l_document := l_document || l_temp_str ||TAB||TAB||TAB||g_header_rec.ordered_date||NEWLINE;
6354: IF l_event_type <> 'RETURNORDER' THEN
6355: fnd_message.set_name('IBE','IBE_PRMT_SHIP_METH_COLON');
6356: l_temp_str := null;
6357: l_temp_str := fnd_message.get;
6358: l_document := l_document || l_temp_str ||TAB||TAB||TAB||l_Ship_Method||NEWLINE;
6359: END IF;

Line 6357: l_temp_str := fnd_message.get;

6353: l_document := l_document || l_temp_str ||TAB||TAB||TAB||g_header_rec.ordered_date||NEWLINE;
6354: IF l_event_type <> 'RETURNORDER' THEN
6355: fnd_message.set_name('IBE','IBE_PRMT_SHIP_METH_COLON');
6356: l_temp_str := null;
6357: l_temp_str := fnd_message.get;
6358: l_document := l_document || l_temp_str ||TAB||TAB||TAB||l_Ship_Method||NEWLINE;
6359: END IF;
6360: -- Need to get the user type. For individual users, show address, for others skip.
6361: l_user_type := wf_engine.GetItemAttrText (

Line 6368: fnd_message.set_name('IBE','IBE_PRMT_SHIP_INFO_COLON');

6364: aname => 'STOREUSERTYPE'
6365: );
6366: IF ((l_user_type = 'IBE_INDIVIDUAL'and l_event_type = 'RETURNORDER') or (l_event_type <> 'RETURNORDER')) THEN
6367: IF (l_event_type <> 'RETURNORDER') THEN
6368: fnd_message.set_name('IBE','IBE_PRMT_SHIP_INFO_COLON');
6369: l_temp_str := null;
6370: l_temp_str := fnd_message.get;
6371:
6372: l_document := l_document || l_temp_str ||TAB||TAB||l_party_first_name||' '||l_party_last_name||NEWLINE;

Line 6370: l_temp_str := fnd_message.get;

6366: IF ((l_user_type = 'IBE_INDIVIDUAL'and l_event_type = 'RETURNORDER') or (l_event_type <> 'RETURNORDER')) THEN
6367: IF (l_event_type <> 'RETURNORDER') THEN
6368: fnd_message.set_name('IBE','IBE_PRMT_SHIP_INFO_COLON');
6369: l_temp_str := null;
6370: l_temp_str := fnd_message.get;
6371:
6372: l_document := l_document || l_temp_str ||TAB||TAB||l_party_first_name||' '||l_party_last_name||NEWLINE;
6373: l_document := l_document || TAB||TAB||TAB||TAB||g_header_rec.ship_to_address1||NEWLINE;
6374: IF ( rtrim(g_header_rec.ship_to_address2) IS NOT NULL ) THEN

Line 6389: fnd_message.set_name('IBE','IBE_EOS_BILLING_ADDRESS_COLON');

6385: l_document := l_document || g_header_rec.ship_to_postal_code||NEWLINE;
6386: l_document := l_document || TAB||TAB||TAB||TAB||g_header_rec.ship_to_country;
6387:
6388: ELSE ---3334542
6389: fnd_message.set_name('IBE','IBE_EOS_BILLING_ADDRESS_COLON');
6390: l_temp_str := null;
6391: l_temp_str := fnd_message.get;
6392:
6393: l_document := l_document || l_temp_str ||TAB||TAB||l_party_first_name||' '||l_party_last_name||NEWLINE;

Line 6391: l_temp_str := fnd_message.get;

6387:
6388: ELSE ---3334542
6389: fnd_message.set_name('IBE','IBE_EOS_BILLING_ADDRESS_COLON');
6390: l_temp_str := null;
6391: l_temp_str := fnd_message.get;
6392:
6393: l_document := l_document || l_temp_str ||TAB||TAB||l_party_first_name||' '||l_party_last_name||NEWLINE;
6394: l_document := l_document || TAB||TAB||TAB||TAB||g_header_rec.bill_to_address1||NEWLINE;
6395: IF ( rtrim(g_header_rec.bill_to_address2) IS NOT NULL ) THEN

Line 6417: fnd_message.set_name('IBE','IBE_PRMT_ORDER_NO_COLON');

6413: --null;
6414: --END IF;
6415: ELSIF ( l_event_type = 'ORDERROR') THEN
6416: -- IF (display_type = 'text/plain' ) THEN
6417: fnd_message.set_name('IBE','IBE_PRMT_ORDER_NO_COLON');
6418: l_temp_str := null;
6419: l_temp_str := fnd_message.get;
6420: l_document := l_document || l_temp_str||TAB||TAB||TAB||g_header_rec.order_number||NEWLINE;
6421: fnd_message.set_name('IBE','IBE_PRMT_OOE_NO_COLON');

Line 6419: l_temp_str := fnd_message.get;

6415: ELSIF ( l_event_type = 'ORDERROR') THEN
6416: -- IF (display_type = 'text/plain' ) THEN
6417: fnd_message.set_name('IBE','IBE_PRMT_ORDER_NO_COLON');
6418: l_temp_str := null;
6419: l_temp_str := fnd_message.get;
6420: l_document := l_document || l_temp_str||TAB||TAB||TAB||g_header_rec.order_number||NEWLINE;
6421: fnd_message.set_name('IBE','IBE_PRMT_OOE_NO_COLON');
6422: l_temp_str := null;
6423: l_temp_str := fnd_message.get;

Line 6421: fnd_message.set_name('IBE','IBE_PRMT_OOE_NO_COLON');

6417: fnd_message.set_name('IBE','IBE_PRMT_ORDER_NO_COLON');
6418: l_temp_str := null;
6419: l_temp_str := fnd_message.get;
6420: l_document := l_document || l_temp_str||TAB||TAB||TAB||g_header_rec.order_number||NEWLINE;
6421: fnd_message.set_name('IBE','IBE_PRMT_OOE_NO_COLON');
6422: l_temp_str := null;
6423: l_temp_str := fnd_message.get;
6424: l_document := l_document|| l_temp_str ||TAB||TAB||TAB ||g_header_rec.order_number||NEWLINE;
6425: fnd_message.set_name('IBE','IBE_PRMT_COMPANY_NAME_COLON');

Line 6423: l_temp_str := fnd_message.get;

6419: l_temp_str := fnd_message.get;
6420: l_document := l_document || l_temp_str||TAB||TAB||TAB||g_header_rec.order_number||NEWLINE;
6421: fnd_message.set_name('IBE','IBE_PRMT_OOE_NO_COLON');
6422: l_temp_str := null;
6423: l_temp_str := fnd_message.get;
6424: l_document := l_document|| l_temp_str ||TAB||TAB||TAB ||g_header_rec.order_number||NEWLINE;
6425: fnd_message.set_name('IBE','IBE_PRMT_COMPANY_NAME_COLON');
6426: l_temp_str := null;
6427: l_temp_str := fnd_message.get;

Line 6425: fnd_message.set_name('IBE','IBE_PRMT_COMPANY_NAME_COLON');

6421: fnd_message.set_name('IBE','IBE_PRMT_OOE_NO_COLON');
6422: l_temp_str := null;
6423: l_temp_str := fnd_message.get;
6424: l_document := l_document|| l_temp_str ||TAB||TAB||TAB ||g_header_rec.order_number||NEWLINE;
6425: fnd_message.set_name('IBE','IBE_PRMT_COMPANY_NAME_COLON');
6426: l_temp_str := null;
6427: l_temp_str := fnd_message.get;
6428: l_document := l_document|| l_temp_str ||TAB||TAB ||g_header_rec.customer_name||NEWLINE;
6429: fnd_message.set_name('IBE','IBE_PRMT_NAME_COLON');

Line 6427: l_temp_str := fnd_message.get;

6423: l_temp_str := fnd_message.get;
6424: l_document := l_document|| l_temp_str ||TAB||TAB||TAB ||g_header_rec.order_number||NEWLINE;
6425: fnd_message.set_name('IBE','IBE_PRMT_COMPANY_NAME_COLON');
6426: l_temp_str := null;
6427: l_temp_str := fnd_message.get;
6428: l_document := l_document|| l_temp_str ||TAB||TAB ||g_header_rec.customer_name||NEWLINE;
6429: fnd_message.set_name('IBE','IBE_PRMT_NAME_COLON');
6430: l_temp_str := null;
6431: l_temp_str := fnd_message.get;

Line 6429: fnd_message.set_name('IBE','IBE_PRMT_NAME_COLON');

6425: fnd_message.set_name('IBE','IBE_PRMT_COMPANY_NAME_COLON');
6426: l_temp_str := null;
6427: l_temp_str := fnd_message.get;
6428: l_document := l_document|| l_temp_str ||TAB||TAB ||g_header_rec.customer_name||NEWLINE;
6429: fnd_message.set_name('IBE','IBE_PRMT_NAME_COLON');
6430: l_temp_str := null;
6431: l_temp_str := fnd_message.get;
6432: l_document := l_document || l_temp_str||TAB||TAB||TAB ||l_party_first_name||' '||l_party_last_name||NEWLINE;
6433: fnd_message.set_name('IBE','IBE_PRMT_DATE_SUBMIT_COLON');

Line 6431: l_temp_str := fnd_message.get;

6427: l_temp_str := fnd_message.get;
6428: l_document := l_document|| l_temp_str ||TAB||TAB ||g_header_rec.customer_name||NEWLINE;
6429: fnd_message.set_name('IBE','IBE_PRMT_NAME_COLON');
6430: l_temp_str := null;
6431: l_temp_str := fnd_message.get;
6432: l_document := l_document || l_temp_str||TAB||TAB||TAB ||l_party_first_name||' '||l_party_last_name||NEWLINE;
6433: fnd_message.set_name('IBE','IBE_PRMT_DATE_SUBMIT_COLON');
6434: l_temp_str := null;
6435: l_temp_str := fnd_message.get;

Line 6433: fnd_message.set_name('IBE','IBE_PRMT_DATE_SUBMIT_COLON');

6429: fnd_message.set_name('IBE','IBE_PRMT_NAME_COLON');
6430: l_temp_str := null;
6431: l_temp_str := fnd_message.get;
6432: l_document := l_document || l_temp_str||TAB||TAB||TAB ||l_party_first_name||' '||l_party_last_name||NEWLINE;
6433: fnd_message.set_name('IBE','IBE_PRMT_DATE_SUBMIT_COLON');
6434: l_temp_str := null;
6435: l_temp_str := fnd_message.get;
6436: l_document := l_document || l_temp_str||TAB||TAB ||g_header_rec.ordered_date||NEWLINE;
6437: -- Need to restrict the end user to view the net price.

Line 6435: l_temp_str := fnd_message.get;

6431: l_temp_str := fnd_message.get;
6432: l_document := l_document || l_temp_str||TAB||TAB||TAB ||l_party_first_name||' '||l_party_last_name||NEWLINE;
6433: fnd_message.set_name('IBE','IBE_PRMT_DATE_SUBMIT_COLON');
6434: l_temp_str := null;
6435: l_temp_str := fnd_message.get;
6436: l_document := l_document || l_temp_str||TAB||TAB ||g_header_rec.ordered_date||NEWLINE;
6437: -- Need to restrict the end user to view the net price.
6438:
6439: l_view_net_price_flag := wf_engine.GetItemAttrText (

Line 6446: fnd_message.set_name('IBE','IBE_PRMT_ORDER_TOTAL_COLON');

6442: aname => 'VIEWNETPRICE'
6443: );
6444:
6445: IF l_view_net_price_flag = 'Y' THEN
6446: fnd_message.set_name('IBE','IBE_PRMT_ORDER_TOTAL_COLON');
6447: l_temp_str := null;
6448: l_temp_str := fnd_message.get;
6449: l_document := l_document|| l_temp_str ||TAB||TAB||to_char(g_header_rec.order_total)||NEWLINE;
6450: fnd_message.set_name('IBE','IBE_PRMT_PAY_METH_COLON');

Line 6448: l_temp_str := fnd_message.get;

6444:
6445: IF l_view_net_price_flag = 'Y' THEN
6446: fnd_message.set_name('IBE','IBE_PRMT_ORDER_TOTAL_COLON');
6447: l_temp_str := null;
6448: l_temp_str := fnd_message.get;
6449: l_document := l_document|| l_temp_str ||TAB||TAB||to_char(g_header_rec.order_total)||NEWLINE;
6450: fnd_message.set_name('IBE','IBE_PRMT_PAY_METH_COLON');
6451: l_temp_str := null;
6452: l_temp_str := fnd_message.get;

Line 6450: fnd_message.set_name('IBE','IBE_PRMT_PAY_METH_COLON');

6446: fnd_message.set_name('IBE','IBE_PRMT_ORDER_TOTAL_COLON');
6447: l_temp_str := null;
6448: l_temp_str := fnd_message.get;
6449: l_document := l_document|| l_temp_str ||TAB||TAB||to_char(g_header_rec.order_total)||NEWLINE;
6450: fnd_message.set_name('IBE','IBE_PRMT_PAY_METH_COLON');
6451: l_temp_str := null;
6452: l_temp_str := fnd_message.get;
6453: l_document := l_document|| l_temp_str ||TAB||TAB ||g_header_rec.payment_type_code||NEWLINE;
6454: END IF;

Line 6452: l_temp_str := fnd_message.get;

6448: l_temp_str := fnd_message.get;
6449: l_document := l_document|| l_temp_str ||TAB||TAB||to_char(g_header_rec.order_total)||NEWLINE;
6450: fnd_message.set_name('IBE','IBE_PRMT_PAY_METH_COLON');
6451: l_temp_str := null;
6452: l_temp_str := fnd_message.get;
6453: l_document := l_document|| l_temp_str ||TAB||TAB ||g_header_rec.payment_type_code||NEWLINE;
6454: END IF;
6455: fnd_message.set_name('IBE','IBE_PRMT_REASON_CODE_COLON');
6456: l_temp_str := null;

Line 6455: fnd_message.set_name('IBE','IBE_PRMT_REASON_CODE_COLON');

6451: l_temp_str := null;
6452: l_temp_str := fnd_message.get;
6453: l_document := l_document|| l_temp_str ||TAB||TAB ||g_header_rec.payment_type_code||NEWLINE;
6454: END IF;
6455: fnd_message.set_name('IBE','IBE_PRMT_REASON_CODE_COLON');
6456: l_temp_str := null;
6457: l_temp_str := fnd_message.get;
6458: l_document := l_document || l_temp_str ||TAB||TAB || NEWLINE ;
6459: l_document := l_document ||TAB||TAB||TAB|| l_errmsg_data ||NEWLINE;

Line 6457: l_temp_str := fnd_message.get;

6453: l_document := l_document|| l_temp_str ||TAB||TAB ||g_header_rec.payment_type_code||NEWLINE;
6454: END IF;
6455: fnd_message.set_name('IBE','IBE_PRMT_REASON_CODE_COLON');
6456: l_temp_str := null;
6457: l_temp_str := fnd_message.get;
6458: l_document := l_document || l_temp_str ||TAB||TAB || NEWLINE ;
6459: l_document := l_document ||TAB||TAB||TAB|| l_errmsg_data ||NEWLINE;
6460: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
6461: ibe_util.debug('Error Message '|| l_errmsg_data);

Line 6653: fnd_message.set_name('IBE','IBE_PRMT_CUST_CNTCT_INFO');

6649: End Loop;
6650:
6651: IF ( l_event_type = 'CUSTASSIST' ) THEN
6652: --IF ( display_type = 'text/plain' ) THEN
6653: fnd_message.set_name('IBE','IBE_PRMT_CUST_CNTCT_INFO');
6654: l_temp_str := null;
6655: l_temp_str := fnd_message.get;
6656: l_document := l_document || NEWLINE ||l_temp_str ||NEWLINE||NEWLINE;
6657:

Line 6655: l_temp_str := fnd_message.get;

6651: IF ( l_event_type = 'CUSTASSIST' ) THEN
6652: --IF ( display_type = 'text/plain' ) THEN
6653: fnd_message.set_name('IBE','IBE_PRMT_CUST_CNTCT_INFO');
6654: l_temp_str := null;
6655: l_temp_str := fnd_message.get;
6656: l_document := l_document || NEWLINE ||l_temp_str ||NEWLINE||NEWLINE;
6657:
6658: fnd_message.set_name('IBE','IBE_PRMT_CNTCT_NAME_COL');
6659: l_temp_str := null;

Line 6658: fnd_message.set_name('IBE','IBE_PRMT_CNTCT_NAME_COL');

6654: l_temp_str := null;
6655: l_temp_str := fnd_message.get;
6656: l_document := l_document || NEWLINE ||l_temp_str ||NEWLINE||NEWLINE;
6657:
6658: fnd_message.set_name('IBE','IBE_PRMT_CNTCT_NAME_COL');
6659: l_temp_str := null;
6660: l_temp_str := fnd_message.get;
6661: l_document := l_document || l_temp_str ||TAB||TAB||TAB||l_contact_name||NEWLINE;
6662:

Line 6660: l_temp_str := fnd_message.get;

6656: l_document := l_document || NEWLINE ||l_temp_str ||NEWLINE||NEWLINE;
6657:
6658: fnd_message.set_name('IBE','IBE_PRMT_CNTCT_NAME_COL');
6659: l_temp_str := null;
6660: l_temp_str := fnd_message.get;
6661: l_document := l_document || l_temp_str ||TAB||TAB||TAB||l_contact_name||NEWLINE;
6662:
6663: fnd_message.set_name('IBE','IBE_PRMT_CNTCT_NUM_COL');
6664: l_temp_str := null;

Line 6663: fnd_message.set_name('IBE','IBE_PRMT_CNTCT_NUM_COL');

6659: l_temp_str := null;
6660: l_temp_str := fnd_message.get;
6661: l_document := l_document || l_temp_str ||TAB||TAB||TAB||l_contact_name||NEWLINE;
6662:
6663: fnd_message.set_name('IBE','IBE_PRMT_CNTCT_NUM_COL');
6664: l_temp_str := null;
6665: l_temp_str := fnd_message.get;
6666: l_document := l_document || l_temp_str ||TAB||TAB||TAB||l_contact_number||NEWLINE;
6667:

Line 6665: l_temp_str := fnd_message.get;

6661: l_document := l_document || l_temp_str ||TAB||TAB||TAB||l_contact_name||NEWLINE;
6662:
6663: fnd_message.set_name('IBE','IBE_PRMT_CNTCT_NUM_COL');
6664: l_temp_str := null;
6665: l_temp_str := fnd_message.get;
6666: l_document := l_document || l_temp_str ||TAB||TAB||TAB||l_contact_number||NEWLINE;
6667:
6668: fnd_message.set_name('IBE','IBE_PRMT_CNTCT_EMAIL_COL');
6669: l_temp_str := null;

Line 6668: fnd_message.set_name('IBE','IBE_PRMT_CNTCT_EMAIL_COL');

6664: l_temp_str := null;
6665: l_temp_str := fnd_message.get;
6666: l_document := l_document || l_temp_str ||TAB||TAB||TAB||l_contact_number||NEWLINE;
6667:
6668: fnd_message.set_name('IBE','IBE_PRMT_CNTCT_EMAIL_COL');
6669: l_temp_str := null;
6670: l_temp_str := fnd_message.get;
6671: l_document := l_document || l_temp_str ||TAB||TAB||l_contact_email||NEWLINE;
6672:

Line 6670: l_temp_str := fnd_message.get;

6666: l_document := l_document || l_temp_str ||TAB||TAB||TAB||l_contact_number||NEWLINE;
6667:
6668: fnd_message.set_name('IBE','IBE_PRMT_CNTCT_EMAIL_COL');
6669: l_temp_str := null;
6670: l_temp_str := fnd_message.get;
6671: l_document := l_document || l_temp_str ||TAB||TAB||l_contact_email||NEWLINE;
6672:
6673: fnd_message.set_name('IBE','IBE_PRMT_COMMENTS_COL');
6674: l_temp_str := null;

Line 6673: fnd_message.set_name('IBE','IBE_PRMT_COMMENTS_COL');

6669: l_temp_str := null;
6670: l_temp_str := fnd_message.get;
6671: l_document := l_document || l_temp_str ||TAB||TAB||l_contact_email||NEWLINE;
6672:
6673: fnd_message.set_name('IBE','IBE_PRMT_COMMENTS_COL');
6674: l_temp_str := null;
6675: l_temp_str := fnd_message.get;
6676: l_document := l_document || l_temp_str ||TAB||TAB||TAB||l_comments ||NEWLINE||NEWLINE;
6677:

Line 6675: l_temp_str := fnd_message.get;

6671: l_document := l_document || l_temp_str ||TAB||TAB||l_contact_email||NEWLINE;
6672:
6673: fnd_message.set_name('IBE','IBE_PRMT_COMMENTS_COL');
6674: l_temp_str := null;
6675: l_temp_str := fnd_message.get;
6676: l_document := l_document || l_temp_str ||TAB||TAB||TAB||l_comments ||NEWLINE||NEWLINE;
6677:
6678: fnd_message.set_name('IBE','IBE_PRMT_ORDER_NO_COLON');
6679: l_temp_str := null;

Line 6678: fnd_message.set_name('IBE','IBE_PRMT_ORDER_NO_COLON');

6674: l_temp_str := null;
6675: l_temp_str := fnd_message.get;
6676: l_document := l_document || l_temp_str ||TAB||TAB||TAB||l_comments ||NEWLINE||NEWLINE;
6677:
6678: fnd_message.set_name('IBE','IBE_PRMT_ORDER_NO_COLON');
6679: l_temp_str := null;
6680: l_temp_str := fnd_message.get;
6681: l_document := l_document || l_temp_str ||TAB||TAB||TAB||g_header_rec.order_number||NEWLINE;
6682:

Line 6680: l_temp_str := fnd_message.get;

6676: l_document := l_document || l_temp_str ||TAB||TAB||TAB||l_comments ||NEWLINE||NEWLINE;
6677:
6678: fnd_message.set_name('IBE','IBE_PRMT_ORDER_NO_COLON');
6679: l_temp_str := null;
6680: l_temp_str := fnd_message.get;
6681: l_document := l_document || l_temp_str ||TAB||TAB||TAB||g_header_rec.order_number||NEWLINE;
6682:
6683: fnd_message.set_name('IBE','IBE_PRMT_ORDER_DATE_COLON');
6684: l_temp_str := null;

Line 6683: fnd_message.set_name('IBE','IBE_PRMT_ORDER_DATE_COLON');

6679: l_temp_str := null;
6680: l_temp_str := fnd_message.get;
6681: l_document := l_document || l_temp_str ||TAB||TAB||TAB||g_header_rec.order_number||NEWLINE;
6682:
6683: fnd_message.set_name('IBE','IBE_PRMT_ORDER_DATE_COLON');
6684: l_temp_str := null;
6685: l_temp_str := fnd_message.get;
6686: l_document := l_document || l_temp_str ||TAB||TAB||TAB||g_header_rec.ordered_date||NEWLINE||NEWLINE;
6687:

Line 6685: l_temp_str := fnd_message.get;

6681: l_document := l_document || l_temp_str ||TAB||TAB||TAB||g_header_rec.order_number||NEWLINE;
6682:
6683: fnd_message.set_name('IBE','IBE_PRMT_ORDER_DATE_COLON');
6684: l_temp_str := null;
6685: l_temp_str := fnd_message.get;
6686: l_document := l_document || l_temp_str ||TAB||TAB||TAB||g_header_rec.ordered_date||NEWLINE||NEWLINE;
6687:
6688: fnd_message.set_name('IBE','IBE_PRMT_SHIP_METH_COLON');
6689: l_temp_str := null;

Line 6688: fnd_message.set_name('IBE','IBE_PRMT_SHIP_METH_COLON');

6684: l_temp_str := null;
6685: l_temp_str := fnd_message.get;
6686: l_document := l_document || l_temp_str ||TAB||TAB||TAB||g_header_rec.ordered_date||NEWLINE||NEWLINE;
6687:
6688: fnd_message.set_name('IBE','IBE_PRMT_SHIP_METH_COLON');
6689: l_temp_str := null;
6690: l_temp_str := fnd_message.get;
6691: l_document := l_document || l_temp_str ||TAB||TAB||TAB||l_ship_method||NEWLINE;
6692:

Line 6690: l_temp_str := fnd_message.get;

6686: l_document := l_document || l_temp_str ||TAB||TAB||TAB||g_header_rec.ordered_date||NEWLINE||NEWLINE;
6687:
6688: fnd_message.set_name('IBE','IBE_PRMT_SHIP_METH_COLON');
6689: l_temp_str := null;
6690: l_temp_str := fnd_message.get;
6691: l_document := l_document || l_temp_str ||TAB||TAB||TAB||l_ship_method||NEWLINE;
6692:
6693: fnd_message.set_name('IBE','IBE_PRMT_CUST_NAME_COLON');
6694: l_temp_str := null;

Line 6693: fnd_message.set_name('IBE','IBE_PRMT_CUST_NAME_COLON');

6689: l_temp_str := null;
6690: l_temp_str := fnd_message.get;
6691: l_document := l_document || l_temp_str ||TAB||TAB||TAB||l_ship_method||NEWLINE;
6692:
6693: fnd_message.set_name('IBE','IBE_PRMT_CUST_NAME_COLON');
6694: l_temp_str := null;
6695: l_temp_str := fnd_message.get;
6696: l_document := l_document || l_temp_str ||TAB||TAB||TAB||g_header_rec.customer_name||NEWLINE;
6697: l_document := l_document || TAB||TAB||TAB||TAB||l_ship_address||NEWLINE;

Line 6695: l_temp_str := fnd_message.get;

6691: l_document := l_document || l_temp_str ||TAB||TAB||TAB||l_ship_method||NEWLINE;
6692:
6693: fnd_message.set_name('IBE','IBE_PRMT_CUST_NAME_COLON');
6694: l_temp_str := null;
6695: l_temp_str := fnd_message.get;
6696: l_document := l_document || l_temp_str ||TAB||TAB||TAB||g_header_rec.customer_name||NEWLINE;
6697: l_document := l_document || TAB||TAB||TAB||TAB||l_ship_address||NEWLINE;
6698: l_document := l_document || TAB||TAB||TAB||TAB||g_header_rec.ship_to_city||NEWLINE;
6699: l_document := l_document || TAB||TAB||TAB||TAB||g_header_rec.ship_to_state||' ';

Line 6707: fnd_message.set_name('IBE','IBE_PRMT_ORDER_NO_COLON');

6703: --null;
6704: --END IF;
6705: ELSIF ( l_event_type = 'SALESASSIST' ) THEN
6706: --IF (display_type = 'text/plain' ) THEN
6707: fnd_message.set_name('IBE','IBE_PRMT_ORDER_NO_COLON');
6708: l_temp_str := null;
6709: l_temp_str := fnd_message.get;
6710: l_document := l_document || l_temp_str ||TAB||TAB||g_header_rec.order_number||NEWLINE;
6711:

Line 6709: l_temp_str := fnd_message.get;

6705: ELSIF ( l_event_type = 'SALESASSIST' ) THEN
6706: --IF (display_type = 'text/plain' ) THEN
6707: fnd_message.set_name('IBE','IBE_PRMT_ORDER_NO_COLON');
6708: l_temp_str := null;
6709: l_temp_str := fnd_message.get;
6710: l_document := l_document || l_temp_str ||TAB||TAB||g_header_rec.order_number||NEWLINE;
6711:
6712: fnd_message.set_name('IBE','IBE_PRMT_OOE_NO_COLON');
6713: l_temp_str := null;

Line 6712: fnd_message.set_name('IBE','IBE_PRMT_OOE_NO_COLON');

6708: l_temp_str := null;
6709: l_temp_str := fnd_message.get;
6710: l_document := l_document || l_temp_str ||TAB||TAB||g_header_rec.order_number||NEWLINE;
6711:
6712: fnd_message.set_name('IBE','IBE_PRMT_OOE_NO_COLON');
6713: l_temp_str := null;
6714: l_temp_str := fnd_message.get;
6715: l_document := l_document|| l_temp_str ||TAB||TAB||TAB ||g_header_rec.order_number||NEWLINE;
6716:

Line 6714: l_temp_str := fnd_message.get;

6710: l_document := l_document || l_temp_str ||TAB||TAB||g_header_rec.order_number||NEWLINE;
6711:
6712: fnd_message.set_name('IBE','IBE_PRMT_OOE_NO_COLON');
6713: l_temp_str := null;
6714: l_temp_str := fnd_message.get;
6715: l_document := l_document|| l_temp_str ||TAB||TAB||TAB ||g_header_rec.order_number||NEWLINE;
6716:
6717: fnd_message.set_name('IBE','IBE_PRMT_ORDER_DATE_COLON');
6718: l_temp_str := null;

Line 6717: fnd_message.set_name('IBE','IBE_PRMT_ORDER_DATE_COLON');

6713: l_temp_str := null;
6714: l_temp_str := fnd_message.get;
6715: l_document := l_document|| l_temp_str ||TAB||TAB||TAB ||g_header_rec.order_number||NEWLINE;
6716:
6717: fnd_message.set_name('IBE','IBE_PRMT_ORDER_DATE_COLON');
6718: l_temp_str := null;
6719: l_temp_str := fnd_message.get;
6720: l_document := l_document || l_temp_str ||TAB||TAB||g_header_rec.ordered_date||NEWLINE;
6721:

Line 6719: l_temp_str := fnd_message.get;

6715: l_document := l_document|| l_temp_str ||TAB||TAB||TAB ||g_header_rec.order_number||NEWLINE;
6716:
6717: fnd_message.set_name('IBE','IBE_PRMT_ORDER_DATE_COLON');
6718: l_temp_str := null;
6719: l_temp_str := fnd_message.get;
6720: l_document := l_document || l_temp_str ||TAB||TAB||g_header_rec.ordered_date||NEWLINE;
6721:
6722: fnd_message.set_name('IBE','IBE_PRMT_SHIP_METH_COLON');
6723: l_temp_str := null;

Line 6722: fnd_message.set_name('IBE','IBE_PRMT_SHIP_METH_COLON');

6718: l_temp_str := null;
6719: l_temp_str := fnd_message.get;
6720: l_document := l_document || l_temp_str ||TAB||TAB||g_header_rec.ordered_date||NEWLINE;
6721:
6722: fnd_message.set_name('IBE','IBE_PRMT_SHIP_METH_COLON');
6723: l_temp_str := null;
6724: l_temp_str := fnd_message.get;
6725: l_document := l_document || l_temp_str||TAB||TAB||l_ship_method||NEWLINE;
6726:

Line 6724: l_temp_str := fnd_message.get;

6720: l_document := l_document || l_temp_str ||TAB||TAB||g_header_rec.ordered_date||NEWLINE;
6721:
6722: fnd_message.set_name('IBE','IBE_PRMT_SHIP_METH_COLON');
6723: l_temp_str := null;
6724: l_temp_str := fnd_message.get;
6725: l_document := l_document || l_temp_str||TAB||TAB||l_ship_method||NEWLINE;
6726:
6727: fnd_message.set_name('IBE','IBE_PRMT_CUST_CNTCT_INFO');
6728: l_temp_str := null;

Line 6727: fnd_message.set_name('IBE','IBE_PRMT_CUST_CNTCT_INFO');

6723: l_temp_str := null;
6724: l_temp_str := fnd_message.get;
6725: l_document := l_document || l_temp_str||TAB||TAB||l_ship_method||NEWLINE;
6726:
6727: fnd_message.set_name('IBE','IBE_PRMT_CUST_CNTCT_INFO');
6728: l_temp_str := null;
6729: l_temp_str := fnd_message.get;
6730: l_document := l_document || NEWLINE ||l_temp_str ||NEWLINE||NEWLINE;
6731:

Line 6729: l_temp_str := fnd_message.get;

6725: l_document := l_document || l_temp_str||TAB||TAB||l_ship_method||NEWLINE;
6726:
6727: fnd_message.set_name('IBE','IBE_PRMT_CUST_CNTCT_INFO');
6728: l_temp_str := null;
6729: l_temp_str := fnd_message.get;
6730: l_document := l_document || NEWLINE ||l_temp_str ||NEWLINE||NEWLINE;
6731:
6732: fnd_message.set_name('IBE','IBE_PRMT_CNTCT_NAME_COL');
6733: l_temp_str := null;

Line 6732: fnd_message.set_name('IBE','IBE_PRMT_CNTCT_NAME_COL');

6728: l_temp_str := null;
6729: l_temp_str := fnd_message.get;
6730: l_document := l_document || NEWLINE ||l_temp_str ||NEWLINE||NEWLINE;
6731:
6732: fnd_message.set_name('IBE','IBE_PRMT_CNTCT_NAME_COL');
6733: l_temp_str := null;
6734: l_temp_str := fnd_message.get;
6735: l_document := l_document || l_temp_str ||TAB||TAB||l_contact_name||NEWLINE;
6736:

Line 6734: l_temp_str := fnd_message.get;

6730: l_document := l_document || NEWLINE ||l_temp_str ||NEWLINE||NEWLINE;
6731:
6732: fnd_message.set_name('IBE','IBE_PRMT_CNTCT_NAME_COL');
6733: l_temp_str := null;
6734: l_temp_str := fnd_message.get;
6735: l_document := l_document || l_temp_str ||TAB||TAB||l_contact_name||NEWLINE;
6736:
6737: fnd_message.set_name('IBE','IBE_PRMT_CNTCT_NUM_COL');
6738: l_temp_str := null;

Line 6737: fnd_message.set_name('IBE','IBE_PRMT_CNTCT_NUM_COL');

6733: l_temp_str := null;
6734: l_temp_str := fnd_message.get;
6735: l_document := l_document || l_temp_str ||TAB||TAB||l_contact_name||NEWLINE;
6736:
6737: fnd_message.set_name('IBE','IBE_PRMT_CNTCT_NUM_COL');
6738: l_temp_str := null;
6739: l_temp_str := fnd_message.get;
6740: l_document := l_document || l_temp_str ||TAB||TAB||l_contact_number||NEWLINE;
6741:

Line 6739: l_temp_str := fnd_message.get;

6735: l_document := l_document || l_temp_str ||TAB||TAB||l_contact_name||NEWLINE;
6736:
6737: fnd_message.set_name('IBE','IBE_PRMT_CNTCT_NUM_COL');
6738: l_temp_str := null;
6739: l_temp_str := fnd_message.get;
6740: l_document := l_document || l_temp_str ||TAB||TAB||l_contact_number||NEWLINE;
6741:
6742: fnd_message.set_name('IBE','IBE_PRMT_CNTCT_EMAIL_COL');
6743: l_temp_str := null;

Line 6742: fnd_message.set_name('IBE','IBE_PRMT_CNTCT_EMAIL_COL');

6738: l_temp_str := null;
6739: l_temp_str := fnd_message.get;
6740: l_document := l_document || l_temp_str ||TAB||TAB||l_contact_number||NEWLINE;
6741:
6742: fnd_message.set_name('IBE','IBE_PRMT_CNTCT_EMAIL_COL');
6743: l_temp_str := null;
6744: l_temp_str := fnd_message.get;
6745: l_document := l_document || l_temp_str ||TAB||l_contact_email||NEWLINE;
6746:

Line 6744: l_temp_str := fnd_message.get;

6740: l_document := l_document || l_temp_str ||TAB||TAB||l_contact_number||NEWLINE;
6741:
6742: fnd_message.set_name('IBE','IBE_PRMT_CNTCT_EMAIL_COL');
6743: l_temp_str := null;
6744: l_temp_str := fnd_message.get;
6745: l_document := l_document || l_temp_str ||TAB||l_contact_email||NEWLINE;
6746:
6747: fnd_message.set_name('IBE','IBE_PRMT_COMMENTS_COL');
6748: l_temp_str := null;

Line 6747: fnd_message.set_name('IBE','IBE_PRMT_COMMENTS_COL');

6743: l_temp_str := null;
6744: l_temp_str := fnd_message.get;
6745: l_document := l_document || l_temp_str ||TAB||l_contact_email||NEWLINE;
6746:
6747: fnd_message.set_name('IBE','IBE_PRMT_COMMENTS_COL');
6748: l_temp_str := null;
6749: l_temp_str := fnd_message.get;
6750: l_document := l_document || l_temp_str ||TAB||TAB||l_comments ||NEWLINE;
6751:

Line 6749: l_temp_str := fnd_message.get;

6745: l_document := l_document || l_temp_str ||TAB||l_contact_email||NEWLINE;
6746:
6747: fnd_message.set_name('IBE','IBE_PRMT_COMMENTS_COL');
6748: l_temp_str := null;
6749: l_temp_str := fnd_message.get;
6750: l_document := l_document || l_temp_str ||TAB||TAB||l_comments ||NEWLINE;
6751:
6752: fnd_message.set_name('IBE','IBE_PRMT_ORD_BILL_INFO');
6753: l_temp_str := null;

Line 6752: fnd_message.set_name('IBE','IBE_PRMT_ORD_BILL_INFO');

6748: l_temp_str := null;
6749: l_temp_str := fnd_message.get;
6750: l_document := l_document || l_temp_str ||TAB||TAB||l_comments ||NEWLINE;
6751:
6752: fnd_message.set_name('IBE','IBE_PRMT_ORD_BILL_INFO');
6753: l_temp_str := null;
6754: l_temp_str := fnd_message.get;
6755: l_document := l_document || NEWLINE ||l_temp_str ||NEWLINE||NEWLINE;
6756:

Line 6754: l_temp_str := fnd_message.get;

6750: l_document := l_document || l_temp_str ||TAB||TAB||l_comments ||NEWLINE;
6751:
6752: fnd_message.set_name('IBE','IBE_PRMT_ORD_BILL_INFO');
6753: l_temp_str := null;
6754: l_temp_str := fnd_message.get;
6755: l_document := l_document || NEWLINE ||l_temp_str ||NEWLINE||NEWLINE;
6756:
6757: fnd_message.set_name('IBE','IBE_PRMT_CUST_NAME_COLON');
6758: l_temp_str := null;

Line 6757: fnd_message.set_name('IBE','IBE_PRMT_CUST_NAME_COLON');

6753: l_temp_str := null;
6754: l_temp_str := fnd_message.get;
6755: l_document := l_document || NEWLINE ||l_temp_str ||NEWLINE||NEWLINE;
6756:
6757: fnd_message.set_name('IBE','IBE_PRMT_CUST_NAME_COLON');
6758: l_temp_str := null;
6759: l_temp_str := fnd_message.get;
6760: l_document := l_document || l_temp_str ||TAB||TAB||g_header_rec.customer_name||NEWLINE;
6761:

Line 6759: l_temp_str := fnd_message.get;

6755: l_document := l_document || NEWLINE ||l_temp_str ||NEWLINE||NEWLINE;
6756:
6757: fnd_message.set_name('IBE','IBE_PRMT_CUST_NAME_COLON');
6758: l_temp_str := null;
6759: l_temp_str := fnd_message.get;
6760: l_document := l_document || l_temp_str ||TAB||TAB||g_header_rec.customer_name||NEWLINE;
6761:
6762: fnd_message.set_name('IBE','IBE_PRMT_ADDRESS_COLON');
6763: l_temp_str := null;

Line 6762: fnd_message.set_name('IBE','IBE_PRMT_ADDRESS_COLON');

6758: l_temp_str := null;
6759: l_temp_str := fnd_message.get;
6760: l_document := l_document || l_temp_str ||TAB||TAB||g_header_rec.customer_name||NEWLINE;
6761:
6762: fnd_message.set_name('IBE','IBE_PRMT_ADDRESS_COLON');
6763: l_temp_str := null;
6764: l_temp_str := fnd_message.get;
6765: l_document := l_document || l_temp_str ||TAB||TAB||l_bill_address||NEWLINE;
6766:

Line 6764: l_temp_str := fnd_message.get;

6760: l_document := l_document || l_temp_str ||TAB||TAB||g_header_rec.customer_name||NEWLINE;
6761:
6762: fnd_message.set_name('IBE','IBE_PRMT_ADDRESS_COLON');
6763: l_temp_str := null;
6764: l_temp_str := fnd_message.get;
6765: l_document := l_document || l_temp_str ||TAB||TAB||l_bill_address||NEWLINE;
6766:
6767: fnd_message.set_name('IBE','IBE_PRMT_CITY_COLON');
6768: l_temp_str := null;

Line 6767: fnd_message.set_name('IBE','IBE_PRMT_CITY_COLON');

6763: l_temp_str := null;
6764: l_temp_str := fnd_message.get;
6765: l_document := l_document || l_temp_str ||TAB||TAB||l_bill_address||NEWLINE;
6766:
6767: fnd_message.set_name('IBE','IBE_PRMT_CITY_COLON');
6768: l_temp_str := null;
6769: l_temp_str := fnd_message.get;
6770: l_document := l_document || l_temp_str ||TAB||TAB||TAB||g_header_rec.bill_to_city||NEWLINE;
6771:

Line 6769: l_temp_str := fnd_message.get;

6765: l_document := l_document || l_temp_str ||TAB||TAB||l_bill_address||NEWLINE;
6766:
6767: fnd_message.set_name('IBE','IBE_PRMT_CITY_COLON');
6768: l_temp_str := null;
6769: l_temp_str := fnd_message.get;
6770: l_document := l_document || l_temp_str ||TAB||TAB||TAB||g_header_rec.bill_to_city||NEWLINE;
6771:
6772: fnd_message.set_name('IBE','IBE_PRMT_STATE_PRO_COLON');
6773: l_temp_str := null;

Line 6772: fnd_message.set_name('IBE','IBE_PRMT_STATE_PRO_COLON');

6768: l_temp_str := null;
6769: l_temp_str := fnd_message.get;
6770: l_document := l_document || l_temp_str ||TAB||TAB||TAB||g_header_rec.bill_to_city||NEWLINE;
6771:
6772: fnd_message.set_name('IBE','IBE_PRMT_STATE_PRO_COLON');
6773: l_temp_str := null;
6774: l_temp_str := fnd_message.get;
6775: l_document := l_document || l_temp_str ||TAB||TAB||g_header_rec.bill_to_state||NEWLINE;
6776:

Line 6774: l_temp_str := fnd_message.get;

6770: l_document := l_document || l_temp_str ||TAB||TAB||TAB||g_header_rec.bill_to_city||NEWLINE;
6771:
6772: fnd_message.set_name('IBE','IBE_PRMT_STATE_PRO_COLON');
6773: l_temp_str := null;
6774: l_temp_str := fnd_message.get;
6775: l_document := l_document || l_temp_str ||TAB||TAB||g_header_rec.bill_to_state||NEWLINE;
6776:
6777: fnd_message.set_name('IBE','IBE_PRMT_ZIP_POSTAL_COLON');
6778: l_temp_str := null;

Line 6777: fnd_message.set_name('IBE','IBE_PRMT_ZIP_POSTAL_COLON');

6773: l_temp_str := null;
6774: l_temp_str := fnd_message.get;
6775: l_document := l_document || l_temp_str ||TAB||TAB||g_header_rec.bill_to_state||NEWLINE;
6776:
6777: fnd_message.set_name('IBE','IBE_PRMT_ZIP_POSTAL_COLON');
6778: l_temp_str := null;
6779: l_temp_str := fnd_message.get;
6780: l_document := l_document || l_temp_str ||TAB||g_header_rec.bill_to_postal_code||NEWLINE;
6781:

Line 6779: l_temp_str := fnd_message.get;

6775: l_document := l_document || l_temp_str ||TAB||TAB||g_header_rec.bill_to_state||NEWLINE;
6776:
6777: fnd_message.set_name('IBE','IBE_PRMT_ZIP_POSTAL_COLON');
6778: l_temp_str := null;
6779: l_temp_str := fnd_message.get;
6780: l_document := l_document || l_temp_str ||TAB||g_header_rec.bill_to_postal_code||NEWLINE;
6781:
6782: fnd_message.set_name('IBE','IBE_PRMT_COUNTRY_COLON');
6783: l_temp_str := null;

Line 6782: fnd_message.set_name('IBE','IBE_PRMT_COUNTRY_COLON');

6778: l_temp_str := null;
6779: l_temp_str := fnd_message.get;
6780: l_document := l_document || l_temp_str ||TAB||g_header_rec.bill_to_postal_code||NEWLINE;
6781:
6782: fnd_message.set_name('IBE','IBE_PRMT_COUNTRY_COLON');
6783: l_temp_str := null;
6784: l_temp_str := fnd_message.get;
6785: l_document := l_document || l_temp_str ||TAB||TAB||g_header_rec.bill_to_country||NEWLINE;
6786:

Line 6784: l_temp_str := fnd_message.get;

6780: l_document := l_document || l_temp_str ||TAB||g_header_rec.bill_to_postal_code||NEWLINE;
6781:
6782: fnd_message.set_name('IBE','IBE_PRMT_COUNTRY_COLON');
6783: l_temp_str := null;
6784: l_temp_str := fnd_message.get;
6785: l_document := l_document || l_temp_str ||TAB||TAB||g_header_rec.bill_to_country||NEWLINE;
6786:
6787: fnd_message.set_name('IBE','IBE_PRMT_CNTCT_NAME_COL');
6788: l_temp_str := null;

Line 6787: fnd_message.set_name('IBE','IBE_PRMT_CNTCT_NAME_COL');

6783: l_temp_str := null;
6784: l_temp_str := fnd_message.get;
6785: l_document := l_document || l_temp_str ||TAB||TAB||g_header_rec.bill_to_country||NEWLINE;
6786:
6787: fnd_message.set_name('IBE','IBE_PRMT_CNTCT_NAME_COL');
6788: l_temp_str := null;
6789: l_temp_str := fnd_message.get;
6790: l_document := l_document || l_temp_str ||TAB||TAB||l_contact_name||NEWLINE;
6791:

Line 6789: l_temp_str := fnd_message.get;

6785: l_document := l_document || l_temp_str ||TAB||TAB||g_header_rec.bill_to_country||NEWLINE;
6786:
6787: fnd_message.set_name('IBE','IBE_PRMT_CNTCT_NAME_COL');
6788: l_temp_str := null;
6789: l_temp_str := fnd_message.get;
6790: l_document := l_document || l_temp_str ||TAB||TAB||l_contact_name||NEWLINE;
6791:
6792: fnd_message.set_name('IBE','IBE_PRMT_TEL_NO_COLON');
6793: l_temp_str := null;

Line 6792: fnd_message.set_name('IBE','IBE_PRMT_TEL_NO_COLON');

6788: l_temp_str := null;
6789: l_temp_str := fnd_message.get;
6790: l_document := l_document || l_temp_str ||TAB||TAB||l_contact_name||NEWLINE;
6791:
6792: fnd_message.set_name('IBE','IBE_PRMT_TEL_NO_COLON');
6793: l_temp_str := null;
6794: l_temp_str := fnd_message.get;
6795: l_document := l_document || l_temp_str ||TAB||l_contact_number||NEWLINE;
6796:

Line 6794: l_temp_str := fnd_message.get;

6790: l_document := l_document || l_temp_str ||TAB||TAB||l_contact_name||NEWLINE;
6791:
6792: fnd_message.set_name('IBE','IBE_PRMT_TEL_NO_COLON');
6793: l_temp_str := null;
6794: l_temp_str := fnd_message.get;
6795: l_document := l_document || l_temp_str ||TAB||l_contact_number||NEWLINE;
6796:
6797: fnd_message.set_name('IBE','IBE_PRMT_FAX_NO_COLON');
6798: l_temp_str := null;

Line 6797: fnd_message.set_name('IBE','IBE_PRMT_FAX_NO_COLON');

6793: l_temp_str := null;
6794: l_temp_str := fnd_message.get;
6795: l_document := l_document || l_temp_str ||TAB||l_contact_number||NEWLINE;
6796:
6797: fnd_message.set_name('IBE','IBE_PRMT_FAX_NO_COLON');
6798: l_temp_str := null;
6799: l_temp_str := fnd_message.get;
6800: l_document := l_document || l_temp_str ||TAB||TAB||l_contact_fax||NEWLINE;
6801:

Line 6799: l_temp_str := fnd_message.get;

6795: l_document := l_document || l_temp_str ||TAB||l_contact_number||NEWLINE;
6796:
6797: fnd_message.set_name('IBE','IBE_PRMT_FAX_NO_COLON');
6798: l_temp_str := null;
6799: l_temp_str := fnd_message.get;
6800: l_document := l_document || l_temp_str ||TAB||TAB||l_contact_fax||NEWLINE;
6801:
6802: fnd_message.set_name('IBE','IBE_PRMT_ORD_SHIP_INFOR');
6803: l_temp_str := null;

Line 6802: fnd_message.set_name('IBE','IBE_PRMT_ORD_SHIP_INFOR');

6798: l_temp_str := null;
6799: l_temp_str := fnd_message.get;
6800: l_document := l_document || l_temp_str ||TAB||TAB||l_contact_fax||NEWLINE;
6801:
6802: fnd_message.set_name('IBE','IBE_PRMT_ORD_SHIP_INFOR');
6803: l_temp_str := null;
6804: l_temp_str := fnd_message.get;
6805: l_document := l_document || NEWLINE ||l_temp_str ||NEWLINE||NEWLINE;
6806:

Line 6804: l_temp_str := fnd_message.get;

6800: l_document := l_document || l_temp_str ||TAB||TAB||l_contact_fax||NEWLINE;
6801:
6802: fnd_message.set_name('IBE','IBE_PRMT_ORD_SHIP_INFOR');
6803: l_temp_str := null;
6804: l_temp_str := fnd_message.get;
6805: l_document := l_document || NEWLINE ||l_temp_str ||NEWLINE||NEWLINE;
6806:
6807: fnd_message.set_name('IBE','IBE_PRMT_CUST_NAME_COLON');
6808: l_temp_str := null;

Line 6807: fnd_message.set_name('IBE','IBE_PRMT_CUST_NAME_COLON');

6803: l_temp_str := null;
6804: l_temp_str := fnd_message.get;
6805: l_document := l_document || NEWLINE ||l_temp_str ||NEWLINE||NEWLINE;
6806:
6807: fnd_message.set_name('IBE','IBE_PRMT_CUST_NAME_COLON');
6808: l_temp_str := null;
6809: l_temp_str := fnd_message.get;
6810: l_document := l_document || l_temp_str ||TAB||TAB||g_header_rec.customer_name||NEWLINE;
6811:

Line 6809: l_temp_str := fnd_message.get;

6805: l_document := l_document || NEWLINE ||l_temp_str ||NEWLINE||NEWLINE;
6806:
6807: fnd_message.set_name('IBE','IBE_PRMT_CUST_NAME_COLON');
6808: l_temp_str := null;
6809: l_temp_str := fnd_message.get;
6810: l_document := l_document || l_temp_str ||TAB||TAB||g_header_rec.customer_name||NEWLINE;
6811:
6812: fnd_message.set_name('IBE','IBE_PRMT_ADDRESS_COLON');
6813: l_temp_str := null;

Line 6812: fnd_message.set_name('IBE','IBE_PRMT_ADDRESS_COLON');

6808: l_temp_str := null;
6809: l_temp_str := fnd_message.get;
6810: l_document := l_document || l_temp_str ||TAB||TAB||g_header_rec.customer_name||NEWLINE;
6811:
6812: fnd_message.set_name('IBE','IBE_PRMT_ADDRESS_COLON');
6813: l_temp_str := null;
6814: l_temp_str := fnd_message.get;
6815: l_document := l_document || l_temp_str ||TAB||TAB||l_ship_address||NEWLINE;
6816:

Line 6814: l_temp_str := fnd_message.get;

6810: l_document := l_document || l_temp_str ||TAB||TAB||g_header_rec.customer_name||NEWLINE;
6811:
6812: fnd_message.set_name('IBE','IBE_PRMT_ADDRESS_COLON');
6813: l_temp_str := null;
6814: l_temp_str := fnd_message.get;
6815: l_document := l_document || l_temp_str ||TAB||TAB||l_ship_address||NEWLINE;
6816:
6817: fnd_message.set_name('IBE','IBE_PRMT_CITY_COLON');
6818: l_temp_str := null;

Line 6817: fnd_message.set_name('IBE','IBE_PRMT_CITY_COLON');

6813: l_temp_str := null;
6814: l_temp_str := fnd_message.get;
6815: l_document := l_document || l_temp_str ||TAB||TAB||l_ship_address||NEWLINE;
6816:
6817: fnd_message.set_name('IBE','IBE_PRMT_CITY_COLON');
6818: l_temp_str := null;
6819: l_temp_str := fnd_message.get;
6820: l_document := l_document || l_temp_str||TAB||TAB||TAB||g_header_rec.ship_to_city||NEWLINE;
6821:

Line 6819: l_temp_str := fnd_message.get;

6815: l_document := l_document || l_temp_str ||TAB||TAB||l_ship_address||NEWLINE;
6816:
6817: fnd_message.set_name('IBE','IBE_PRMT_CITY_COLON');
6818: l_temp_str := null;
6819: l_temp_str := fnd_message.get;
6820: l_document := l_document || l_temp_str||TAB||TAB||TAB||g_header_rec.ship_to_city||NEWLINE;
6821:
6822: fnd_message.set_name('IBE','IBE_PRMT_STATE_PRO_COLON');
6823: l_temp_str := null;

Line 6822: fnd_message.set_name('IBE','IBE_PRMT_STATE_PRO_COLON');

6818: l_temp_str := null;
6819: l_temp_str := fnd_message.get;
6820: l_document := l_document || l_temp_str||TAB||TAB||TAB||g_header_rec.ship_to_city||NEWLINE;
6821:
6822: fnd_message.set_name('IBE','IBE_PRMT_STATE_PRO_COLON');
6823: l_temp_str := null;
6824: l_temp_str := fnd_message.get;
6825: l_document := l_document || l_temp_str||TAB||TAB||g_header_rec.ship_to_state||NEWLINE;
6826:

Line 6824: l_temp_str := fnd_message.get;

6820: l_document := l_document || l_temp_str||TAB||TAB||TAB||g_header_rec.ship_to_city||NEWLINE;
6821:
6822: fnd_message.set_name('IBE','IBE_PRMT_STATE_PRO_COLON');
6823: l_temp_str := null;
6824: l_temp_str := fnd_message.get;
6825: l_document := l_document || l_temp_str||TAB||TAB||g_header_rec.ship_to_state||NEWLINE;
6826:
6827: fnd_message.set_name('IBE','IBE_PRMT_ZIP_POSTAL_COLON');
6828: l_temp_str := null;

Line 6827: fnd_message.set_name('IBE','IBE_PRMT_ZIP_POSTAL_COLON');

6823: l_temp_str := null;
6824: l_temp_str := fnd_message.get;
6825: l_document := l_document || l_temp_str||TAB||TAB||g_header_rec.ship_to_state||NEWLINE;
6826:
6827: fnd_message.set_name('IBE','IBE_PRMT_ZIP_POSTAL_COLON');
6828: l_temp_str := null;
6829: l_temp_str := fnd_message.get;
6830: l_document := l_document || l_temp_str||TAB||g_header_rec.ship_to_postal_code||NEWLINE;
6831:

Line 6829: l_temp_str := fnd_message.get;

6825: l_document := l_document || l_temp_str||TAB||TAB||g_header_rec.ship_to_state||NEWLINE;
6826:
6827: fnd_message.set_name('IBE','IBE_PRMT_ZIP_POSTAL_COLON');
6828: l_temp_str := null;
6829: l_temp_str := fnd_message.get;
6830: l_document := l_document || l_temp_str||TAB||g_header_rec.ship_to_postal_code||NEWLINE;
6831:
6832: fnd_message.set_name('IBE','IBE_PRMT_COUNTRY_COLON');
6833: l_temp_str := null;

Line 6832: fnd_message.set_name('IBE','IBE_PRMT_COUNTRY_COLON');

6828: l_temp_str := null;
6829: l_temp_str := fnd_message.get;
6830: l_document := l_document || l_temp_str||TAB||g_header_rec.ship_to_postal_code||NEWLINE;
6831:
6832: fnd_message.set_name('IBE','IBE_PRMT_COUNTRY_COLON');
6833: l_temp_str := null;
6834: l_temp_str := fnd_message.get;
6835: l_document := l_document || l_temp_str||TAB||TAB||g_header_rec.ship_to_country||NEWLINE;
6836:

Line 6834: l_temp_str := fnd_message.get;

6830: l_document := l_document || l_temp_str||TAB||g_header_rec.ship_to_postal_code||NEWLINE;
6831:
6832: fnd_message.set_name('IBE','IBE_PRMT_COUNTRY_COLON');
6833: l_temp_str := null;
6834: l_temp_str := fnd_message.get;
6835: l_document := l_document || l_temp_str||TAB||TAB||g_header_rec.ship_to_country||NEWLINE;
6836:
6837: fnd_message.set_name('IBE','IBE_PRMT_CNTCT_NAME_COL');
6838: l_temp_str := null;

Line 6837: fnd_message.set_name('IBE','IBE_PRMT_CNTCT_NAME_COL');

6833: l_temp_str := null;
6834: l_temp_str := fnd_message.get;
6835: l_document := l_document || l_temp_str||TAB||TAB||g_header_rec.ship_to_country||NEWLINE;
6836:
6837: fnd_message.set_name('IBE','IBE_PRMT_CNTCT_NAME_COL');
6838: l_temp_str := null;
6839: l_temp_str := fnd_message.get;
6840: l_document := l_document || l_temp_str||TAB||TAB||l_contact_name||NEWLINE;
6841:

Line 6839: l_temp_str := fnd_message.get;

6835: l_document := l_document || l_temp_str||TAB||TAB||g_header_rec.ship_to_country||NEWLINE;
6836:
6837: fnd_message.set_name('IBE','IBE_PRMT_CNTCT_NAME_COL');
6838: l_temp_str := null;
6839: l_temp_str := fnd_message.get;
6840: l_document := l_document || l_temp_str||TAB||TAB||l_contact_name||NEWLINE;
6841:
6842: fnd_message.set_name('IBE','IBE_PRMT_TEL_NO_COLON');
6843: l_temp_str := null;

Line 6842: fnd_message.set_name('IBE','IBE_PRMT_TEL_NO_COLON');

6838: l_temp_str := null;
6839: l_temp_str := fnd_message.get;
6840: l_document := l_document || l_temp_str||TAB||TAB||l_contact_name||NEWLINE;
6841:
6842: fnd_message.set_name('IBE','IBE_PRMT_TEL_NO_COLON');
6843: l_temp_str := null;
6844: l_temp_str := fnd_message.get;
6845: l_document := l_document || l_temp_str||TAB||l_contact_number||NEWLINE;
6846:

Line 6844: l_temp_str := fnd_message.get;

6840: l_document := l_document || l_temp_str||TAB||TAB||l_contact_name||NEWLINE;
6841:
6842: fnd_message.set_name('IBE','IBE_PRMT_TEL_NO_COLON');
6843: l_temp_str := null;
6844: l_temp_str := fnd_message.get;
6845: l_document := l_document || l_temp_str||TAB||l_contact_number||NEWLINE;
6846:
6847: fnd_message.set_name('IBE','IBE_PRMT_FAX_NO_COLON');
6848: l_temp_str := null;

Line 6847: fnd_message.set_name('IBE','IBE_PRMT_FAX_NO_COLON');

6843: l_temp_str := null;
6844: l_temp_str := fnd_message.get;
6845: l_document := l_document || l_temp_str||TAB||l_contact_number||NEWLINE;
6846:
6847: fnd_message.set_name('IBE','IBE_PRMT_FAX_NO_COLON');
6848: l_temp_str := null;
6849: l_temp_str := fnd_message.get;
6850: l_document := l_document || l_temp_str||TAB||TAB||l_contact_fax||NEWLINE;
6851: --ELSE

Line 6849: l_temp_str := fnd_message.get;

6845: l_document := l_document || l_temp_str||TAB||l_contact_number||NEWLINE;
6846:
6847: fnd_message.set_name('IBE','IBE_PRMT_FAX_NO_COLON');
6848: l_temp_str := null;
6849: l_temp_str := fnd_message.get;
6850: l_document := l_document || l_temp_str||TAB||TAB||l_contact_fax||NEWLINE;
6851: --ELSE
6852: --null;
6853: --END IF;

Line 6934: fnd_message.set_name('IBE','IBE_PRMT_PRODUCT_G');

6930: itemkey => l_item_key,
6931: aname => 'QUOTEID');
6932:
6933: IF (l_event_type = 'RETURNORDER') THEN -- For Return Order WF Notification
6934: fnd_message.set_name('IBE','IBE_PRMT_PRODUCT_G');
6935: l_temp_str := null;
6936: l_temp_str := fnd_message.get;
6937: l_document := rpad(l_temp_str,7)||' ';
6938: fnd_message.set_name('IBE','IBE_PRMT_DESCRIPTION_G');

Line 6936: l_temp_str := fnd_message.get;

6932:
6933: IF (l_event_type = 'RETURNORDER') THEN -- For Return Order WF Notification
6934: fnd_message.set_name('IBE','IBE_PRMT_PRODUCT_G');
6935: l_temp_str := null;
6936: l_temp_str := fnd_message.get;
6937: l_document := rpad(l_temp_str,7)||' ';
6938: fnd_message.set_name('IBE','IBE_PRMT_DESCRIPTION_G');
6939: l_temp_str := null;
6940: l_temp_str := fnd_message.get;

Line 6938: fnd_message.set_name('IBE','IBE_PRMT_DESCRIPTION_G');

6934: fnd_message.set_name('IBE','IBE_PRMT_PRODUCT_G');
6935: l_temp_str := null;
6936: l_temp_str := fnd_message.get;
6937: l_document := rpad(l_temp_str,7)||' ';
6938: fnd_message.set_name('IBE','IBE_PRMT_DESCRIPTION_G');
6939: l_temp_str := null;
6940: l_temp_str := fnd_message.get;
6941: l_document := l_document||rpad(l_temp_str,20)||' ';
6942: fnd_message.set_name('IBE','IBE_PRMT_ORDER_NO_DOT_G');

Line 6940: l_temp_str := fnd_message.get;

6936: l_temp_str := fnd_message.get;
6937: l_document := rpad(l_temp_str,7)||' ';
6938: fnd_message.set_name('IBE','IBE_PRMT_DESCRIPTION_G');
6939: l_temp_str := null;
6940: l_temp_str := fnd_message.get;
6941: l_document := l_document||rpad(l_temp_str,20)||' ';
6942: fnd_message.set_name('IBE','IBE_PRMT_ORDER_NO_DOT_G');
6943: l_temp_str := null;
6944: l_temp_str := fnd_message.get;

Line 6942: fnd_message.set_name('IBE','IBE_PRMT_ORDER_NO_DOT_G');

6938: fnd_message.set_name('IBE','IBE_PRMT_DESCRIPTION_G');
6939: l_temp_str := null;
6940: l_temp_str := fnd_message.get;
6941: l_document := l_document||rpad(l_temp_str,20)||' ';
6942: fnd_message.set_name('IBE','IBE_PRMT_ORDER_NO_DOT_G');
6943: l_temp_str := null;
6944: l_temp_str := fnd_message.get;
6945: l_document := l_document||rpad(l_temp_str,9)||' ';
6946: fnd_message.set_name('IBE','IBE_PRMT_QUANTITY_G');

Line 6944: l_temp_str := fnd_message.get;

6940: l_temp_str := fnd_message.get;
6941: l_document := l_document||rpad(l_temp_str,20)||' ';
6942: fnd_message.set_name('IBE','IBE_PRMT_ORDER_NO_DOT_G');
6943: l_temp_str := null;
6944: l_temp_str := fnd_message.get;
6945: l_document := l_document||rpad(l_temp_str,9)||' ';
6946: fnd_message.set_name('IBE','IBE_PRMT_QUANTITY_G');
6947: l_temp_str := null;
6948: l_temp_str := fnd_message.get;

Line 6946: fnd_message.set_name('IBE','IBE_PRMT_QUANTITY_G');

6942: fnd_message.set_name('IBE','IBE_PRMT_ORDER_NO_DOT_G');
6943: l_temp_str := null;
6944: l_temp_str := fnd_message.get;
6945: l_document := l_document||rpad(l_temp_str,9)||' ';
6946: fnd_message.set_name('IBE','IBE_PRMT_QUANTITY_G');
6947: l_temp_str := null;
6948: l_temp_str := fnd_message.get;
6949: l_document := l_document||rpad(l_temp_str,4)||' ';
6950: IF l_view_net_price_flag = 'Y' THEN

Line 6948: l_temp_str := fnd_message.get;

6944: l_temp_str := fnd_message.get;
6945: l_document := l_document||rpad(l_temp_str,9)||' ';
6946: fnd_message.set_name('IBE','IBE_PRMT_QUANTITY_G');
6947: l_temp_str := null;
6948: l_temp_str := fnd_message.get;
6949: l_document := l_document||rpad(l_temp_str,4)||' ';
6950: IF l_view_net_price_flag = 'Y' THEN
6951: fnd_message.set_name('IBE','IBE_PRMT_RETURN_AMOUNT_G');
6952: l_temp_str := null;

Line 6951: fnd_message.set_name('IBE','IBE_PRMT_RETURN_AMOUNT_G');

6947: l_temp_str := null;
6948: l_temp_str := fnd_message.get;
6949: l_document := l_document||rpad(l_temp_str,4)||' ';
6950: IF l_view_net_price_flag = 'Y' THEN
6951: fnd_message.set_name('IBE','IBE_PRMT_RETURN_AMOUNT_G');
6952: l_temp_str := null;
6953: l_temp_str := fnd_message.get;
6954: l_document := l_document||rpad(l_temp_str,15)||' ';
6955: END IF;

Line 6953: l_temp_str := fnd_message.get;

6949: l_document := l_document||rpad(l_temp_str,4)||' ';
6950: IF l_view_net_price_flag = 'Y' THEN
6951: fnd_message.set_name('IBE','IBE_PRMT_RETURN_AMOUNT_G');
6952: l_temp_str := null;
6953: l_temp_str := fnd_message.get;
6954: l_document := l_document||rpad(l_temp_str,15)||' ';
6955: END IF;
6956: fnd_message.set_name('IBE','IBE_PRMT_RETURN_REASON_G');
6957: l_temp_str := null;

Line 6956: fnd_message.set_name('IBE','IBE_PRMT_RETURN_REASON_G');

6952: l_temp_str := null;
6953: l_temp_str := fnd_message.get;
6954: l_document := l_document||rpad(l_temp_str,15)||' ';
6955: END IF;
6956: fnd_message.set_name('IBE','IBE_PRMT_RETURN_REASON_G');
6957: l_temp_str := null;
6958: l_temp_str := fnd_message.get;
6959: l_document := l_document||rpad(l_temp_str,13);
6960: ELSIF (l_event_type = 'CUSTASSIST' OR l_event_type = 'SALESASSIST') THEN -- For Sales Assistance WF Notification

Line 6958: l_temp_str := fnd_message.get;

6954: l_document := l_document||rpad(l_temp_str,15)||' ';
6955: END IF;
6956: fnd_message.set_name('IBE','IBE_PRMT_RETURN_REASON_G');
6957: l_temp_str := null;
6958: l_temp_str := fnd_message.get;
6959: l_document := l_document||rpad(l_temp_str,13);
6960: ELSIF (l_event_type = 'CUSTASSIST' OR l_event_type = 'SALESASSIST') THEN -- For Sales Assistance WF Notification
6961: Open c_get_source_code(l_quote_id);
6962: FETCH c_get_source_code into l_quote_source_code;

Line 6965: fnd_message.set_name('IBE','IBE_M_ACTION_PRMT');

6961: Open c_get_source_code(l_quote_id);
6962: FETCH c_get_source_code into l_quote_source_code;
6963: Close c_get_source_code;
6964: if (l_quote_source_code = 'IStore InstallBase') then
6965: fnd_message.set_name('IBE','IBE_M_ACTION_PRMT');
6966: l_temp_str := null;
6967: l_temp_str := fnd_message.get;
6968: l_document := l_document ||rpad(l_temp_str,9)||' ';
6969:

Line 6967: l_temp_str := fnd_message.get;

6963: Close c_get_source_code;
6964: if (l_quote_source_code = 'IStore InstallBase') then
6965: fnd_message.set_name('IBE','IBE_M_ACTION_PRMT');
6966: l_temp_str := null;
6967: l_temp_str := fnd_message.get;
6968: l_document := l_document ||rpad(l_temp_str,9)||' ';
6969:
6970: end if;
6971: fnd_message.set_name('IBE','IBE_PRMT_PRODUCT_G');

Line 6971: fnd_message.set_name('IBE','IBE_PRMT_PRODUCT_G');

6967: l_temp_str := fnd_message.get;
6968: l_document := l_document ||rpad(l_temp_str,9)||' ';
6969:
6970: end if;
6971: fnd_message.set_name('IBE','IBE_PRMT_PRODUCT_G');
6972: l_temp_str := null;
6973: l_temp_str := fnd_message.get;
6974: l_document := l_document ||rpad(l_temp_str,28)||' ';
6975: fnd_message.set_name('IBE','IBE_PRMT_UOM_SHORT_G');

Line 6973: l_temp_str := fnd_message.get;

6969:
6970: end if;
6971: fnd_message.set_name('IBE','IBE_PRMT_PRODUCT_G');
6972: l_temp_str := null;
6973: l_temp_str := fnd_message.get;
6974: l_document := l_document ||rpad(l_temp_str,28)||' ';
6975: fnd_message.set_name('IBE','IBE_PRMT_UOM_SHORT_G');
6976: l_temp_str := null;
6977: l_temp_str := fnd_message.get;

Line 6975: fnd_message.set_name('IBE','IBE_PRMT_UOM_SHORT_G');

6971: fnd_message.set_name('IBE','IBE_PRMT_PRODUCT_G');
6972: l_temp_str := null;
6973: l_temp_str := fnd_message.get;
6974: l_document := l_document ||rpad(l_temp_str,28)||' ';
6975: fnd_message.set_name('IBE','IBE_PRMT_UOM_SHORT_G');
6976: l_temp_str := null;
6977: l_temp_str := fnd_message.get;
6978: l_document := l_document||lpad(l_temp_str,8)||' ';
6979: fnd_message.set_name('IBE','IBE_PRMT_QUANTITY_G');

Line 6977: l_temp_str := fnd_message.get;

6973: l_temp_str := fnd_message.get;
6974: l_document := l_document ||rpad(l_temp_str,28)||' ';
6975: fnd_message.set_name('IBE','IBE_PRMT_UOM_SHORT_G');
6976: l_temp_str := null;
6977: l_temp_str := fnd_message.get;
6978: l_document := l_document||lpad(l_temp_str,8)||' ';
6979: fnd_message.set_name('IBE','IBE_PRMT_QUANTITY_G');
6980: l_temp_str := null;
6981: l_temp_str := fnd_message.get;

Line 6979: fnd_message.set_name('IBE','IBE_PRMT_QUANTITY_G');

6975: fnd_message.set_name('IBE','IBE_PRMT_UOM_SHORT_G');
6976: l_temp_str := null;
6977: l_temp_str := fnd_message.get;
6978: l_document := l_document||lpad(l_temp_str,8)||' ';
6979: fnd_message.set_name('IBE','IBE_PRMT_QUANTITY_G');
6980: l_temp_str := null;
6981: l_temp_str := fnd_message.get;
6982: l_document := l_document||lpad(l_temp_str,7)||' ';
6983: if (l_quote_source_code <> 'IStore InstallBase') then

Line 6981: l_temp_str := fnd_message.get;

6977: l_temp_str := fnd_message.get;
6978: l_document := l_document||lpad(l_temp_str,8)||' ';
6979: fnd_message.set_name('IBE','IBE_PRMT_QUANTITY_G');
6980: l_temp_str := null;
6981: l_temp_str := fnd_message.get;
6982: l_document := l_document||lpad(l_temp_str,7)||' ';
6983: if (l_quote_source_code <> 'IStore InstallBase') then
6984: fnd_message.set_name('IBE','Shippable');
6985: l_temp_str := null;

Line 6984: fnd_message.set_name('IBE','Shippable');

6980: l_temp_str := null;
6981: l_temp_str := fnd_message.get;
6982: l_document := l_document||lpad(l_temp_str,7)||' ';
6983: if (l_quote_source_code <> 'IStore InstallBase') then
6984: fnd_message.set_name('IBE','Shippable');
6985: l_temp_str := null;
6986: l_temp_str := fnd_message.get;
6987: l_document := l_document||lpad(l_temp_str,9)||' ';
6988: end if;

Line 6986: l_temp_str := fnd_message.get;

6982: l_document := l_document||lpad(l_temp_str,7)||' ';
6983: if (l_quote_source_code <> 'IStore InstallBase') then
6984: fnd_message.set_name('IBE','Shippable');
6985: l_temp_str := null;
6986: l_temp_str := fnd_message.get;
6987: l_document := l_document||lpad(l_temp_str,9)||' ';
6988: end if;
6989: IF l_view_net_price_flag = 'Y' THEN
6990: fnd_message.set_name('IBE','IBE_PRMT_AMOUNT_G');

Line 6990: fnd_message.set_name('IBE','IBE_PRMT_AMOUNT_G');

6986: l_temp_str := fnd_message.get;
6987: l_document := l_document||lpad(l_temp_str,9)||' ';
6988: end if;
6989: IF l_view_net_price_flag = 'Y' THEN
6990: fnd_message.set_name('IBE','IBE_PRMT_AMOUNT_G');
6991: l_temp_str := null;
6992: l_temp_str := fnd_message.get;
6993: l_document := l_document||lpad(l_temp_str,15)||' ';
6994: END IF;

Line 6992: l_temp_str := fnd_message.get;

6988: end if;
6989: IF l_view_net_price_flag = 'Y' THEN
6990: fnd_message.set_name('IBE','IBE_PRMT_AMOUNT_G');
6991: l_temp_str := null;
6992: l_temp_str := fnd_message.get;
6993: l_document := l_document||lpad(l_temp_str,15)||' ';
6994: END IF;
6995: ELSE -- For all other WF notifications (Order conf and Contracts negeotiations)
6996: Open c_get_source_code(l_quote_id);

Line 7001: fnd_message.set_name('IBE','IBE_M_ACTION_PRMT');

6997: FETCH c_get_source_code into l_quote_source_code;
6998: Close c_get_source_code;
6999:
7000: if (l_quote_source_code = 'IStore InstallBase') then
7001: fnd_message.set_name('IBE','IBE_M_ACTION_PRMT');
7002: l_temp_str := null;
7003: l_temp_str := fnd_message.get;
7004: l_document := l_document ||rpad(l_temp_str,9)||' ';
7005:

Line 7003: l_temp_str := fnd_message.get;

6999:
7000: if (l_quote_source_code = 'IStore InstallBase') then
7001: fnd_message.set_name('IBE','IBE_M_ACTION_PRMT');
7002: l_temp_str := null;
7003: l_temp_str := fnd_message.get;
7004: l_document := l_document ||rpad(l_temp_str,9)||' ';
7005:
7006: end if;
7007: fnd_message.set_name('IBE','IBE_PRMT_PRODUCT_G');

Line 7007: fnd_message.set_name('IBE','IBE_PRMT_PRODUCT_G');

7003: l_temp_str := fnd_message.get;
7004: l_document := l_document ||rpad(l_temp_str,9)||' ';
7005:
7006: end if;
7007: fnd_message.set_name('IBE','IBE_PRMT_PRODUCT_G');
7008: l_temp_str := null;
7009: l_temp_str := fnd_message.get;
7010: l_document := l_document ||rpad(l_temp_str,28)||' ';
7011: fnd_message.set_name('IBE','IBE_PRMT_UOM_SHORT_G');

Line 7009: l_temp_str := fnd_message.get;

7005:
7006: end if;
7007: fnd_message.set_name('IBE','IBE_PRMT_PRODUCT_G');
7008: l_temp_str := null;
7009: l_temp_str := fnd_message.get;
7010: l_document := l_document ||rpad(l_temp_str,28)||' ';
7011: fnd_message.set_name('IBE','IBE_PRMT_UOM_SHORT_G');
7012: l_temp_str := null;
7013: l_temp_str := fnd_message.get;

Line 7011: fnd_message.set_name('IBE','IBE_PRMT_UOM_SHORT_G');

7007: fnd_message.set_name('IBE','IBE_PRMT_PRODUCT_G');
7008: l_temp_str := null;
7009: l_temp_str := fnd_message.get;
7010: l_document := l_document ||rpad(l_temp_str,28)||' ';
7011: fnd_message.set_name('IBE','IBE_PRMT_UOM_SHORT_G');
7012: l_temp_str := null;
7013: l_temp_str := fnd_message.get;
7014: l_document := l_document||lpad(l_temp_str,8)||' ';
7015: fnd_message.set_name('IBE','IBE_PRMT_QUANTITY_G');

Line 7013: l_temp_str := fnd_message.get;

7009: l_temp_str := fnd_message.get;
7010: l_document := l_document ||rpad(l_temp_str,28)||' ';
7011: fnd_message.set_name('IBE','IBE_PRMT_UOM_SHORT_G');
7012: l_temp_str := null;
7013: l_temp_str := fnd_message.get;
7014: l_document := l_document||lpad(l_temp_str,8)||' ';
7015: fnd_message.set_name('IBE','IBE_PRMT_QUANTITY_G');
7016: l_temp_str := null;
7017: l_temp_str := fnd_message.get;

Line 7015: fnd_message.set_name('IBE','IBE_PRMT_QUANTITY_G');

7011: fnd_message.set_name('IBE','IBE_PRMT_UOM_SHORT_G');
7012: l_temp_str := null;
7013: l_temp_str := fnd_message.get;
7014: l_document := l_document||lpad(l_temp_str,8)||' ';
7015: fnd_message.set_name('IBE','IBE_PRMT_QUANTITY_G');
7016: l_temp_str := null;
7017: l_temp_str := fnd_message.get;
7018: l_document := l_document||lpad(l_temp_str,7)||' ';
7019: if (l_quote_source_code <> 'IStore InstallBase') then

Line 7017: l_temp_str := fnd_message.get;

7013: l_temp_str := fnd_message.get;
7014: l_document := l_document||lpad(l_temp_str,8)||' ';
7015: fnd_message.set_name('IBE','IBE_PRMT_QUANTITY_G');
7016: l_temp_str := null;
7017: l_temp_str := fnd_message.get;
7018: l_document := l_document||lpad(l_temp_str,7)||' ';
7019: if (l_quote_source_code <> 'IStore InstallBase') then
7020: fnd_message.set_name('IBE','Shippable');
7021: l_temp_str := null;

Line 7020: fnd_message.set_name('IBE','Shippable');

7016: l_temp_str := null;
7017: l_temp_str := fnd_message.get;
7018: l_document := l_document||lpad(l_temp_str,7)||' ';
7019: if (l_quote_source_code <> 'IStore InstallBase') then
7020: fnd_message.set_name('IBE','Shippable');
7021: l_temp_str := null;
7022: l_temp_str := fnd_message.get;
7023: l_document := l_document||lpad(l_temp_str,9)||' ';
7024: end if;

Line 7022: l_temp_str := fnd_message.get;

7018: l_document := l_document||lpad(l_temp_str,7)||' ';
7019: if (l_quote_source_code <> 'IStore InstallBase') then
7020: fnd_message.set_name('IBE','Shippable');
7021: l_temp_str := null;
7022: l_temp_str := fnd_message.get;
7023: l_document := l_document||lpad(l_temp_str,9)||' ';
7024: end if;
7025: IF l_view_net_price_flag = 'Y' THEN
7026: fnd_message.set_name('IBE','IBE_PRMT_AMOUNT_G');

Line 7026: fnd_message.set_name('IBE','IBE_PRMT_AMOUNT_G');

7022: l_temp_str := fnd_message.get;
7023: l_document := l_document||lpad(l_temp_str,9)||' ';
7024: end if;
7025: IF l_view_net_price_flag = 'Y' THEN
7026: fnd_message.set_name('IBE','IBE_PRMT_AMOUNT_G');
7027: l_temp_str := null;
7028: l_temp_str := fnd_message.get;
7029: l_document := l_document||lpad(l_temp_str,15)||' ';
7030: END IF;

Line 7028: l_temp_str := fnd_message.get;

7024: end if;
7025: IF l_view_net_price_flag = 'Y' THEN
7026: fnd_message.set_name('IBE','IBE_PRMT_AMOUNT_G');
7027: l_temp_str := null;
7028: l_temp_str := fnd_message.get;
7029: l_document := l_document||lpad(l_temp_str,15)||' ';
7030: END IF;
7031: END IF;
7032:

Line 7807: fnd_message.set_name('IBE','IBE_PRMT_ORD_TAX');

7803: END IF;
7804: END IF;
7805: END LOOP;
7806: IF (l_view_net_price_flag = 'Y' and p_tax_flag = fnd_api.g_true) THEN
7807: fnd_message.set_name('IBE','IBE_PRMT_ORD_TAX');
7808: l_temp_str := null;
7809: l_temp_str := fnd_message.get;
7810: IF (to_char(ord_detail_tbl(i).taxes_total) is not null) THEN
7811: --l_document := l_document ||

Line 7809: l_temp_str := fnd_message.get;

7805: END LOOP;
7806: IF (l_view_net_price_flag = 'Y' and p_tax_flag = fnd_api.g_true) THEN
7807: fnd_message.set_name('IBE','IBE_PRMT_ORD_TAX');
7808: l_temp_str := null;
7809: l_temp_str := fnd_message.get;
7810: IF (to_char(ord_detail_tbl(i).taxes_total) is not null) THEN
7811: --l_document := l_document ||
7812: --lpad(l_temp_str||': '||' '|| to_char(to_number(ord_detail_tbl(i).taxes_total),l_amt_format),72,' ')||NEWLINE;
7813: --ELSE

Line 8200: fnd_message.set_name('IBE','IBE_PRMT_ORD_TAX');

8196: l_string_in := l_string_left;
8197: END LOOP;
8198:
8199: IF l_view_net_price_flag = 'Y' THEN
8200: fnd_message.set_name('IBE','IBE_PRMT_ORD_TAX');
8201: l_temp_str := null;
8202: l_temp_str := fnd_message.get;
8203:
8204: l_document := l_document ||

Line 8202: l_temp_str := fnd_message.get;

8198:
8199: IF l_view_net_price_flag = 'Y' THEN
8200: fnd_message.set_name('IBE','IBE_PRMT_ORD_TAX');
8201: l_temp_str := null;
8202: l_temp_str := fnd_message.get;
8203:
8204: l_document := l_document ||
8205: lpad(l_temp_str||': '||l_curr_sym|| to_char(g_detail_rec.taxes_total,l_amt_format),72,' ')||
8206: NEWLINE;

Line 8347: fnd_message.set_name('IBE','IBE_PRMT_OT_ONE_TIME_PRICE');

8343: l_curr_sym := trim(nvl(curr_sym_rec.symbol,' '));
8344: End Loop;
8345: END IF;
8346: IF l_view_net_price_flag = 'Y' THEN
8347: fnd_message.set_name('IBE','IBE_PRMT_OT_ONE_TIME_PRICE');
8348: l_temp_str := null;
8349: l_temp_str := fnd_message.get;
8350: l_can_amt := ibe_util.nls_number_format(p_number_in => to_char(g_macd_ord_rec.order_total));
8351: l_document := l_document|| lpad(l_temp_str,51,' ')|| ' '|| lpad(l_curr_sym||to_char(to_number(l_can_amt), l_amt_format), 20, ' ')||NEWLINE;

Line 8349: l_temp_str := fnd_message.get;

8345: END IF;
8346: IF l_view_net_price_flag = 'Y' THEN
8347: fnd_message.set_name('IBE','IBE_PRMT_OT_ONE_TIME_PRICE');
8348: l_temp_str := null;
8349: l_temp_str := fnd_message.get;
8350: l_can_amt := ibe_util.nls_number_format(p_number_in => to_char(g_macd_ord_rec.order_total));
8351: l_document := l_document|| lpad(l_temp_str,51,' ')|| ' '|| lpad(l_curr_sym||to_char(to_number(l_can_amt), l_amt_format), 20, ' ')||NEWLINE;
8352:
8353: --Call OM to find the recurring totals

Line 8395: fnd_message.set_name('IBE','IBE_PRMT_SUBTOTAL_COLON');

8391:
8392: --IF (display_type = 'text/plain' ) THEN
8393: IF l_view_net_price_flag = 'Y' THEN
8394:
8395: fnd_message.set_name('IBE','IBE_PRMT_SUBTOTAL_COLON');
8396: l_temp_str := null;
8397: l_temp_str := fnd_message.get;
8398:
8399: l_sub_total := g_header_rec.lines_total;

Line 8397: l_temp_str := fnd_message.get;

8393: IF l_view_net_price_flag = 'Y' THEN
8394:
8395: fnd_message.set_name('IBE','IBE_PRMT_SUBTOTAL_COLON');
8396: l_temp_str := null;
8397: l_temp_str := fnd_message.get;
8398:
8399: l_sub_total := g_header_rec.lines_total;
8400: l_can_amt := ibe_util.nls_number_format(p_number_in => to_char(l_sub_total));
8401: IF l_event_type = 'RETURNORDER' THEN

Line 8408: fnd_message.set_name('IBE','IBE_OT_RET_CHARGES');

8404: l_document := l_document ||lpad(l_temp_str,51,' ')||' '|| lpad(l_curr_sym||to_char(to_number(l_can_amt),l_amt_format),20,' ')||NEWLINE;
8405: END IF;
8406: l_can_amt := ibe_util.nls_number_format(p_number_in => to_char(g_header_rec.charges_total));
8407: IF l_event_type = 'RETURNORDER' THEN
8408: fnd_message.set_name('IBE','IBE_OT_RET_CHARGES');
8409: l_temp_str := null;
8410: l_temp_str := fnd_message.get;
8411:
8412: l_document := l_document || lpad(l_temp_str,44,' ')||' '|| lpad(l_curr_sym||to_char(to_number(l_can_amt),l_amt_format),14,' ')||NEWLINE;

Line 8410: l_temp_str := fnd_message.get;

8406: l_can_amt := ibe_util.nls_number_format(p_number_in => to_char(g_header_rec.charges_total));
8407: IF l_event_type = 'RETURNORDER' THEN
8408: fnd_message.set_name('IBE','IBE_OT_RET_CHARGES');
8409: l_temp_str := null;
8410: l_temp_str := fnd_message.get;
8411:
8412: l_document := l_document || lpad(l_temp_str,44,' ')||' '|| lpad(l_curr_sym||to_char(to_number(l_can_amt),l_amt_format),14,' ')||NEWLINE;
8413: ELSE
8414: fnd_message.set_name('IBE','IBE_PRMT_SHIP_HAND_COLON');

Line 8414: fnd_message.set_name('IBE','IBE_PRMT_SHIP_HAND_COLON');

8410: l_temp_str := fnd_message.get;
8411:
8412: l_document := l_document || lpad(l_temp_str,44,' ')||' '|| lpad(l_curr_sym||to_char(to_number(l_can_amt),l_amt_format),14,' ')||NEWLINE;
8413: ELSE
8414: fnd_message.set_name('IBE','IBE_PRMT_SHIP_HAND_COLON');
8415: l_temp_str := null;
8416: l_temp_str := fnd_message.get;
8417:
8418: l_document := l_document || lpad(l_temp_str,51,' ')||' '|| lpad(l_curr_sym||to_char(to_number(l_can_amt),l_amt_format),20,' ')||NEWLINE;

Line 8416: l_temp_str := fnd_message.get;

8412: l_document := l_document || lpad(l_temp_str,44,' ')||' '|| lpad(l_curr_sym||to_char(to_number(l_can_amt),l_amt_format),14,' ')||NEWLINE;
8413: ELSE
8414: fnd_message.set_name('IBE','IBE_PRMT_SHIP_HAND_COLON');
8415: l_temp_str := null;
8416: l_temp_str := fnd_message.get;
8417:
8418: l_document := l_document || lpad(l_temp_str,51,' ')||' '|| lpad(l_curr_sym||to_char(to_number(l_can_amt),l_amt_format),20,' ')||NEWLINE;
8419: END IF;
8420: fnd_message.set_name('IBE','IBE_PRMT_TAX_EST_COLON');

Line 8420: fnd_message.set_name('IBE','IBE_PRMT_TAX_EST_COLON');

8416: l_temp_str := fnd_message.get;
8417:
8418: l_document := l_document || lpad(l_temp_str,51,' ')||' '|| lpad(l_curr_sym||to_char(to_number(l_can_amt),l_amt_format),20,' ')||NEWLINE;
8419: END IF;
8420: fnd_message.set_name('IBE','IBE_PRMT_TAX_EST_COLON');
8421: l_temp_str := null;
8422: l_temp_str := fnd_message.get;
8423: l_can_amt := ibe_util.nls_number_format(p_number_in => to_char(g_header_rec.taxes_total));
8424: IF l_event_type = 'RETURNORDER' THEN

Line 8422: l_temp_str := fnd_message.get;

8418: l_document := l_document || lpad(l_temp_str,51,' ')||' '|| lpad(l_curr_sym||to_char(to_number(l_can_amt),l_amt_format),20,' ')||NEWLINE;
8419: END IF;
8420: fnd_message.set_name('IBE','IBE_PRMT_TAX_EST_COLON');
8421: l_temp_str := null;
8422: l_temp_str := fnd_message.get;
8423: l_can_amt := ibe_util.nls_number_format(p_number_in => to_char(g_header_rec.taxes_total));
8424: IF l_event_type = 'RETURNORDER' THEN
8425: l_document := l_document || lpad(l_temp_str,44,' ')||' '|| lpad(l_curr_sym||to_char(to_number(l_can_amt),l_amt_format),14,' ')||NEWLINE;
8426: ELSE

Line 8431: fnd_message.set_name('IBE','IBE_PRMT_SC_TOTAL2');

8427: l_document := l_document || lpad(l_temp_str,51,' ')||' '|| lpad(l_curr_sym||to_char(to_number(l_can_amt),l_amt_format),20,' ')||NEWLINE;
8428: END IF;
8429:
8430:
8431: fnd_message.set_name('IBE','IBE_PRMT_SC_TOTAL2');
8432: l_temp_str := null;
8433: l_temp_str := fnd_message.get;
8434: l_can_amt := ibe_util.nls_number_format(p_number_in => to_char(g_header_rec.order_total));
8435: IF l_event_type = 'RETURNORDER' THEN

Line 8433: l_temp_str := fnd_message.get;

8429:
8430:
8431: fnd_message.set_name('IBE','IBE_PRMT_SC_TOTAL2');
8432: l_temp_str := null;
8433: l_temp_str := fnd_message.get;
8434: l_can_amt := ibe_util.nls_number_format(p_number_in => to_char(g_header_rec.order_total));
8435: IF l_event_type = 'RETURNORDER' THEN
8436: l_document := l_document|| lpad(l_temp_str,44,' ')|| ' '|| lpad(l_curr_sym||to_char(to_number(l_can_amt), l_amt_format), 14, ' ')||NEWLINE;
8437: ELSE

Line 8462: fnd_message.set_name('IBE','IBE_PRMT_SC_PAY_NOW_CHARGES');

8458: l_curr_sym := trim(nvl(curr_sym_rec.symbol,' '));
8459: End Loop;
8460: END IF;
8461: IF l_view_net_price_flag = 'Y' THEN
8462: fnd_message.set_name('IBE','IBE_PRMT_SC_PAY_NOW_CHARGES');
8463: l_temp_str := null;
8464: l_temp_str := fnd_message.get;
8465: l_document := l_document || lpad(l_temp_str,51,' ')||NEWLINE;
8466: l_document := l_document || lpad('-',(51-length(l_temp_str)))||rpad('-',(71-(51-(length(l_temp_str)))),'-')||NEWLINE;

Line 8464: l_temp_str := fnd_message.get;

8460: END IF;
8461: IF l_view_net_price_flag = 'Y' THEN
8462: fnd_message.set_name('IBE','IBE_PRMT_SC_PAY_NOW_CHARGES');
8463: l_temp_str := null;
8464: l_temp_str := fnd_message.get;
8465: l_document := l_document || lpad(l_temp_str,51,' ')||NEWLINE;
8466: l_document := l_document || lpad('-',(51-length(l_temp_str)))||rpad('-',(71-(51-(length(l_temp_str)))),'-')||NEWLINE;
8467:
8468: fnd_message.set_name('IBE','IBE_PRMT_SUBTOTAL_COLON');

Line 8468: fnd_message.set_name('IBE','IBE_PRMT_SUBTOTAL_COLON');

8464: l_temp_str := fnd_message.get;
8465: l_document := l_document || lpad(l_temp_str,51,' ')||NEWLINE;
8466: l_document := l_document || lpad('-',(51-length(l_temp_str)))||rpad('-',(71-(51-(length(l_temp_str)))),'-')||NEWLINE;
8467:
8468: fnd_message.set_name('IBE','IBE_PRMT_SUBTOTAL_COLON');
8469: l_temp_str := null;
8470: l_temp_str := fnd_message.get;
8471: l_can_amt := ibe_util.nls_number_format(p_number_in => to_char(g_macd_ord_rec.paynow_lines_total));
8472: l_document := l_document ||lpad(l_temp_str,51,' ')||' '|| lpad(l_curr_sym||to_char(to_number(l_can_amt),l_amt_format),20,' ')||NEWLINE;

Line 8470: l_temp_str := fnd_message.get;

8466: l_document := l_document || lpad('-',(51-length(l_temp_str)))||rpad('-',(71-(51-(length(l_temp_str)))),'-')||NEWLINE;
8467:
8468: fnd_message.set_name('IBE','IBE_PRMT_SUBTOTAL_COLON');
8469: l_temp_str := null;
8470: l_temp_str := fnd_message.get;
8471: l_can_amt := ibe_util.nls_number_format(p_number_in => to_char(g_macd_ord_rec.paynow_lines_total));
8472: l_document := l_document ||lpad(l_temp_str,51,' ')||' '|| lpad(l_curr_sym||to_char(to_number(l_can_amt),l_amt_format),20,' ')||NEWLINE;
8473:
8474: fnd_message.set_name('IBE','IBE_PRMT_TAX_COL');

Line 8474: fnd_message.set_name('IBE','IBE_PRMT_TAX_COL');

8470: l_temp_str := fnd_message.get;
8471: l_can_amt := ibe_util.nls_number_format(p_number_in => to_char(g_macd_ord_rec.paynow_lines_total));
8472: l_document := l_document ||lpad(l_temp_str,51,' ')||' '|| lpad(l_curr_sym||to_char(to_number(l_can_amt),l_amt_format),20,' ')||NEWLINE;
8473:
8474: fnd_message.set_name('IBE','IBE_PRMT_TAX_COL');
8475: l_temp_str := null;
8476: l_temp_str := fnd_message.get;
8477: l_can_amt := ibe_util.nls_number_format(p_number_in => to_char(g_macd_ord_rec.paynow_taxes_total));
8478: l_document := l_document || lpad(l_temp_str,51,' ')||' '|| lpad(l_curr_sym||to_char(to_number(l_can_amt),l_amt_format),20,' ')||NEWLINE;

Line 8476: l_temp_str := fnd_message.get;

8472: l_document := l_document ||lpad(l_temp_str,51,' ')||' '|| lpad(l_curr_sym||to_char(to_number(l_can_amt),l_amt_format),20,' ')||NEWLINE;
8473:
8474: fnd_message.set_name('IBE','IBE_PRMT_TAX_COL');
8475: l_temp_str := null;
8476: l_temp_str := fnd_message.get;
8477: l_can_amt := ibe_util.nls_number_format(p_number_in => to_char(g_macd_ord_rec.paynow_taxes_total));
8478: l_document := l_document || lpad(l_temp_str,51,' ')||' '|| lpad(l_curr_sym||to_char(to_number(l_can_amt),l_amt_format),20,' ')||NEWLINE;
8479:
8480: fnd_message.set_name('IBE','IBE_PRMT_SHIP_HAND_COLON');

Line 8480: fnd_message.set_name('IBE','IBE_PRMT_SHIP_HAND_COLON');

8476: l_temp_str := fnd_message.get;
8477: l_can_amt := ibe_util.nls_number_format(p_number_in => to_char(g_macd_ord_rec.paynow_taxes_total));
8478: l_document := l_document || lpad(l_temp_str,51,' ')||' '|| lpad(l_curr_sym||to_char(to_number(l_can_amt),l_amt_format),20,' ')||NEWLINE;
8479:
8480: fnd_message.set_name('IBE','IBE_PRMT_SHIP_HAND_COLON');
8481: l_temp_str := null;
8482: l_temp_str := fnd_message.get;
8483: l_can_amt := ibe_util.nls_number_format(p_number_in => to_char(g_macd_ord_rec.paynow_charges_total));
8484: l_document := l_document || lpad(l_temp_str,51,' ')||' '|| lpad(l_curr_sym||to_char(to_number(l_can_amt),l_amt_format),20,' ')||NEWLINE;

Line 8482: l_temp_str := fnd_message.get;

8478: l_document := l_document || lpad(l_temp_str,51,' ')||' '|| lpad(l_curr_sym||to_char(to_number(l_can_amt),l_amt_format),20,' ')||NEWLINE;
8479:
8480: fnd_message.set_name('IBE','IBE_PRMT_SHIP_HAND_COLON');
8481: l_temp_str := null;
8482: l_temp_str := fnd_message.get;
8483: l_can_amt := ibe_util.nls_number_format(p_number_in => to_char(g_macd_ord_rec.paynow_charges_total));
8484: l_document := l_document || lpad(l_temp_str,51,' ')||' '|| lpad(l_curr_sym||to_char(to_number(l_can_amt),l_amt_format),20,' ')||NEWLINE;
8485:
8486: fnd_message.set_name('IBE','IBE_PRMT_SC_PN_TOTAL_COL');

Line 8486: fnd_message.set_name('IBE','IBE_PRMT_SC_PN_TOTAL_COL');

8482: l_temp_str := fnd_message.get;
8483: l_can_amt := ibe_util.nls_number_format(p_number_in => to_char(g_macd_ord_rec.paynow_charges_total));
8484: l_document := l_document || lpad(l_temp_str,51,' ')||' '|| lpad(l_curr_sym||to_char(to_number(l_can_amt),l_amt_format),20,' ')||NEWLINE;
8485:
8486: fnd_message.set_name('IBE','IBE_PRMT_SC_PN_TOTAL_COL');
8487: l_temp_str := null;
8488: l_temp_str := fnd_message.get;
8489: l_can_amt := ibe_util.nls_number_format(p_number_in => to_char(g_macd_ord_rec.paynow_order_total));
8490: l_document := l_document|| lpad(l_temp_str,51,' ')|| ' '|| lpad(l_curr_sym||to_char(to_number(l_can_amt), l_amt_format), 20, ' ');

Line 8488: l_temp_str := fnd_message.get;

8484: l_document := l_document || lpad(l_temp_str,51,' ')||' '|| lpad(l_curr_sym||to_char(to_number(l_can_amt),l_amt_format),20,' ')||NEWLINE;
8485:
8486: fnd_message.set_name('IBE','IBE_PRMT_SC_PN_TOTAL_COL');
8487: l_temp_str := null;
8488: l_temp_str := fnd_message.get;
8489: l_can_amt := ibe_util.nls_number_format(p_number_in => to_char(g_macd_ord_rec.paynow_order_total));
8490: l_document := l_document|| lpad(l_temp_str,51,' ')|| ' '|| lpad(l_curr_sym||to_char(to_number(l_can_amt), l_amt_format), 20, ' ');
8491: END IF;
8492: END LOOP;

Line 8852: fnd_message.set_name('IBE','IBE_PRMT_QUOTE_ID_COLON');

8848: ibe_util.debug('GenerateQuoteHeader - quote_header_id - '||g_quote_header_rec.quote_header_id);
8849: END IF;
8850:
8851: --IF (display_type = 'text/plain' ) THEN
8852: fnd_message.set_name('IBE','IBE_PRMT_QUOTE_ID_COLON');
8853: l_temp_str := null;
8854: l_temp_str := fnd_message.get;
8855: l_document := l_document || l_temp_str ||TAB||TAB||g_quote_header_rec.quote_number||NEWLINE;
8856:

Line 8854: l_temp_str := fnd_message.get;

8850:
8851: --IF (display_type = 'text/plain' ) THEN
8852: fnd_message.set_name('IBE','IBE_PRMT_QUOTE_ID_COLON');
8853: l_temp_str := null;
8854: l_temp_str := fnd_message.get;
8855: l_document := l_document || l_temp_str ||TAB||TAB||g_quote_header_rec.quote_number||NEWLINE;
8856:
8857: fnd_message.set_name('IBE','IBE_PRMT_CONTRACT_NO_COLON');
8858: l_temp_str := null;

Line 8857: fnd_message.set_name('IBE','IBE_PRMT_CONTRACT_NO_COLON');

8853: l_temp_str := null;
8854: l_temp_str := fnd_message.get;
8855: l_document := l_document || l_temp_str ||TAB||TAB||g_quote_header_rec.quote_number||NEWLINE;
8856:
8857: fnd_message.set_name('IBE','IBE_PRMT_CONTRACT_NO_COLON');
8858: l_temp_str := null;
8859: l_temp_str := fnd_message.get;
8860: l_document := l_document || l_temp_str ||TAB||l_contract_number||' '||l_contract_modifier||NEWLINE;
8861:

Line 8859: l_temp_str := fnd_message.get;

8855: l_document := l_document || l_temp_str ||TAB||TAB||g_quote_header_rec.quote_number||NEWLINE;
8856:
8857: fnd_message.set_name('IBE','IBE_PRMT_CONTRACT_NO_COLON');
8858: l_temp_str := null;
8859: l_temp_str := fnd_message.get;
8860: l_document := l_document || l_temp_str ||TAB||l_contract_number||' '||l_contract_modifier||NEWLINE;
8861:
8862: fnd_message.set_name('IBE','IBE_PRMT_QUOTE_NAME_COLON');
8863: l_temp_str := null;

Line 8862: fnd_message.set_name('IBE','IBE_PRMT_QUOTE_NAME_COLON');

8858: l_temp_str := null;
8859: l_temp_str := fnd_message.get;
8860: l_document := l_document || l_temp_str ||TAB||l_contract_number||' '||l_contract_modifier||NEWLINE;
8861:
8862: fnd_message.set_name('IBE','IBE_PRMT_QUOTE_NAME_COLON');
8863: l_temp_str := null;
8864: l_temp_str := fnd_message.get;
8865: l_document := l_document || l_temp_str ||TAB||g_quote_header_rec.quote_name||NEWLINE;
8866: /*

Line 8864: l_temp_str := fnd_message.get;

8860: l_document := l_document || l_temp_str ||TAB||l_contract_number||' '||l_contract_modifier||NEWLINE;
8861:
8862: fnd_message.set_name('IBE','IBE_PRMT_QUOTE_NAME_COLON');
8863: l_temp_str := null;
8864: l_temp_str := fnd_message.get;
8865: l_document := l_document || l_temp_str ||TAB||g_quote_header_rec.quote_name||NEWLINE;
8866: /*
8867: fnd_message.set_name('IBE','IBE_PRMT_ORDER_DATE_COLON');
8868: l_temp_str := null;

Line 8867: fnd_message.set_name('IBE','IBE_PRMT_ORDER_DATE_COLON');

8863: l_temp_str := null;
8864: l_temp_str := fnd_message.get;
8865: l_document := l_document || l_temp_str ||TAB||g_quote_header_rec.quote_name||NEWLINE;
8866: /*
8867: fnd_message.set_name('IBE','IBE_PRMT_ORDER_DATE_COLON');
8868: l_temp_str := null;
8869: l_temp_str := fnd_message.get;
8870: l_document := l_document || l_temp_str ||TAB||TAB||g_quote_header_rec.ordered_date||NEWLINE;
8871: */

Line 8869: l_temp_str := fnd_message.get;

8865: l_document := l_document || l_temp_str ||TAB||g_quote_header_rec.quote_name||NEWLINE;
8866: /*
8867: fnd_message.set_name('IBE','IBE_PRMT_ORDER_DATE_COLON');
8868: l_temp_str := null;
8869: l_temp_str := fnd_message.get;
8870: l_document := l_document || l_temp_str ||TAB||TAB||g_quote_header_rec.ordered_date||NEWLINE;
8871: */
8872: fnd_message.set_name('IBE','IBE_PRMT_SHIP_METH_COLON');
8873: l_temp_str := null;

Line 8872: fnd_message.set_name('IBE','IBE_PRMT_SHIP_METH_COLON');

8868: l_temp_str := null;
8869: l_temp_str := fnd_message.get;
8870: l_document := l_document || l_temp_str ||TAB||TAB||g_quote_header_rec.ordered_date||NEWLINE;
8871: */
8872: fnd_message.set_name('IBE','IBE_PRMT_SHIP_METH_COLON');
8873: l_temp_str := null;
8874: l_temp_str := fnd_message.get;
8875: l_document := l_document || l_temp_str ||TAB||TAB||l_ship_method||NEWLINE;
8876:

Line 8874: l_temp_str := fnd_message.get;

8870: l_document := l_document || l_temp_str ||TAB||TAB||g_quote_header_rec.ordered_date||NEWLINE;
8871: */
8872: fnd_message.set_name('IBE','IBE_PRMT_SHIP_METH_COLON');
8873: l_temp_str := null;
8874: l_temp_str := fnd_message.get;
8875: l_document := l_document || l_temp_str ||TAB||TAB||l_ship_method||NEWLINE;
8876:
8877: fnd_message.set_name('IBE','IBE_PRMT_CUST_CNTCT_INFO');
8878: l_temp_str := null;

Line 8877: fnd_message.set_name('IBE','IBE_PRMT_CUST_CNTCT_INFO');

8873: l_temp_str := null;
8874: l_temp_str := fnd_message.get;
8875: l_document := l_document || l_temp_str ||TAB||TAB||l_ship_method||NEWLINE;
8876:
8877: fnd_message.set_name('IBE','IBE_PRMT_CUST_CNTCT_INFO');
8878: l_temp_str := null;
8879: l_temp_str := fnd_message.get;
8880: l_document := l_document || NEWLINE ||l_temp_str ||NEWLINE||NEWLINE;
8881:

Line 8879: l_temp_str := fnd_message.get;

8875: l_document := l_document || l_temp_str ||TAB||TAB||l_ship_method||NEWLINE;
8876:
8877: fnd_message.set_name('IBE','IBE_PRMT_CUST_CNTCT_INFO');
8878: l_temp_str := null;
8879: l_temp_str := fnd_message.get;
8880: l_document := l_document || NEWLINE ||l_temp_str ||NEWLINE||NEWLINE;
8881:
8882: fnd_message.set_name('IBE','IBE_PRMT_CNTCT_NAME_COL');
8883: l_temp_str := null;

Line 8882: fnd_message.set_name('IBE','IBE_PRMT_CNTCT_NAME_COL');

8878: l_temp_str := null;
8879: l_temp_str := fnd_message.get;
8880: l_document := l_document || NEWLINE ||l_temp_str ||NEWLINE||NEWLINE;
8881:
8882: fnd_message.set_name('IBE','IBE_PRMT_CNTCT_NAME_COL');
8883: l_temp_str := null;
8884: l_temp_str := fnd_message.get;
8885: l_document := l_document || l_temp_str ||TAB||TAB||TAB||l_contact_name||NEWLINE;
8886:

Line 8884: l_temp_str := fnd_message.get;

8880: l_document := l_document || NEWLINE ||l_temp_str ||NEWLINE||NEWLINE;
8881:
8882: fnd_message.set_name('IBE','IBE_PRMT_CNTCT_NAME_COL');
8883: l_temp_str := null;
8884: l_temp_str := fnd_message.get;
8885: l_document := l_document || l_temp_str ||TAB||TAB||TAB||l_contact_name||NEWLINE;
8886:
8887: fnd_message.set_name('IBE','IBE_PRMT_CNTCT_NUM_COL');
8888: l_temp_str := null;

Line 8887: fnd_message.set_name('IBE','IBE_PRMT_CNTCT_NUM_COL');

8883: l_temp_str := null;
8884: l_temp_str := fnd_message.get;
8885: l_document := l_document || l_temp_str ||TAB||TAB||TAB||l_contact_name||NEWLINE;
8886:
8887: fnd_message.set_name('IBE','IBE_PRMT_CNTCT_NUM_COL');
8888: l_temp_str := null;
8889: l_temp_str := fnd_message.get;
8890: l_document := l_document || l_temp_str ||TAB||TAB||TAB||l_contact_number||NEWLINE;
8891:

Line 8889: l_temp_str := fnd_message.get;

8885: l_document := l_document || l_temp_str ||TAB||TAB||TAB||l_contact_name||NEWLINE;
8886:
8887: fnd_message.set_name('IBE','IBE_PRMT_CNTCT_NUM_COL');
8888: l_temp_str := null;
8889: l_temp_str := fnd_message.get;
8890: l_document := l_document || l_temp_str ||TAB||TAB||TAB||l_contact_number||NEWLINE;
8891:
8892: fnd_message.set_name('IBE','IBE_PRMT_CNTCT_EMAIL_COL');
8893: l_temp_str := null;

Line 8892: fnd_message.set_name('IBE','IBE_PRMT_CNTCT_EMAIL_COL');

8888: l_temp_str := null;
8889: l_temp_str := fnd_message.get;
8890: l_document := l_document || l_temp_str ||TAB||TAB||TAB||l_contact_number||NEWLINE;
8891:
8892: fnd_message.set_name('IBE','IBE_PRMT_CNTCT_EMAIL_COL');
8893: l_temp_str := null;
8894: l_temp_str := fnd_message.get;
8895: l_document := l_document || l_temp_str ||TAB||TAB||l_contact_email||NEWLINE;
8896:

Line 8894: l_temp_str := fnd_message.get;

8890: l_document := l_document || l_temp_str ||TAB||TAB||TAB||l_contact_number||NEWLINE;
8891:
8892: fnd_message.set_name('IBE','IBE_PRMT_CNTCT_EMAIL_COL');
8893: l_temp_str := null;
8894: l_temp_str := fnd_message.get;
8895: l_document := l_document || l_temp_str ||TAB||TAB||l_contact_email||NEWLINE;
8896:
8897:
8898: If not(l_event_type = 'TERMREJECTED') Then

Line 8904: fnd_message.set_name('IBE','IBE_PRMT_ADDL_TERMS_COLON');

8900: itemtype => l_item_type,
8901: itemkey => l_item_key,
8902: aname => 'COMMENTS'
8903: );
8904: fnd_message.set_name('IBE','IBE_PRMT_ADDL_TERMS_COLON');
8905: l_temp_str := null;
8906: l_temp_str := fnd_message.get;
8907: l_document := l_document || l_temp_str ||TAB||l_comments ||NEWLINE;
8908: End If;

Line 8906: l_temp_str := fnd_message.get;

8902: aname => 'COMMENTS'
8903: );
8904: fnd_message.set_name('IBE','IBE_PRMT_ADDL_TERMS_COLON');
8905: l_temp_str := null;
8906: l_temp_str := fnd_message.get;
8907: l_document := l_document || l_temp_str ||TAB||l_comments ||NEWLINE;
8908: End If;
8909:
8910: fnd_message.set_name('IBE','IBE_PRMT_ORD_BILL_INFO');

Line 8910: fnd_message.set_name('IBE','IBE_PRMT_ORD_BILL_INFO');

8906: l_temp_str := fnd_message.get;
8907: l_document := l_document || l_temp_str ||TAB||l_comments ||NEWLINE;
8908: End If;
8909:
8910: fnd_message.set_name('IBE','IBE_PRMT_ORD_BILL_INFO');
8911: l_temp_str := null;
8912: l_temp_str := fnd_message.get;
8913: l_document := l_document || NEWLINE ||l_temp_str ||NEWLINE||NEWLINE;
8914:

Line 8912: l_temp_str := fnd_message.get;

8908: End If;
8909:
8910: fnd_message.set_name('IBE','IBE_PRMT_ORD_BILL_INFO');
8911: l_temp_str := null;
8912: l_temp_str := fnd_message.get;
8913: l_document := l_document || NEWLINE ||l_temp_str ||NEWLINE||NEWLINE;
8914:
8915: fnd_message.set_name('IBE','IBE_PRMT_CUST_NAME_COLON');
8916: l_temp_str := null;

Line 8915: fnd_message.set_name('IBE','IBE_PRMT_CUST_NAME_COLON');

8911: l_temp_str := null;
8912: l_temp_str := fnd_message.get;
8913: l_document := l_document || NEWLINE ||l_temp_str ||NEWLINE||NEWLINE;
8914:
8915: fnd_message.set_name('IBE','IBE_PRMT_CUST_NAME_COLON');
8916: l_temp_str := null;
8917: l_temp_str := fnd_message.get;
8918: l_document := l_document || l_temp_str ||TAB||TAB||l_bill_to_party_name||NEWLINE;
8919:

Line 8917: l_temp_str := fnd_message.get;

8913: l_document := l_document || NEWLINE ||l_temp_str ||NEWLINE||NEWLINE;
8914:
8915: fnd_message.set_name('IBE','IBE_PRMT_CUST_NAME_COLON');
8916: l_temp_str := null;
8917: l_temp_str := fnd_message.get;
8918: l_document := l_document || l_temp_str ||TAB||TAB||l_bill_to_party_name||NEWLINE;
8919:
8920: fnd_message.set_name('IBE','IBE_PRMT_ADDRESS_COLON');
8921: l_temp_str := null;

Line 8920: fnd_message.set_name('IBE','IBE_PRMT_ADDRESS_COLON');

8916: l_temp_str := null;
8917: l_temp_str := fnd_message.get;
8918: l_document := l_document || l_temp_str ||TAB||TAB||l_bill_to_party_name||NEWLINE;
8919:
8920: fnd_message.set_name('IBE','IBE_PRMT_ADDRESS_COLON');
8921: l_temp_str := null;
8922: l_temp_str := fnd_message.get;
8923: l_document := l_document || l_temp_str ||TAB||TAB||l_bill_to_address||NEWLINE;
8924:

Line 8922: l_temp_str := fnd_message.get;

8918: l_document := l_document || l_temp_str ||TAB||TAB||l_bill_to_party_name||NEWLINE;
8919:
8920: fnd_message.set_name('IBE','IBE_PRMT_ADDRESS_COLON');
8921: l_temp_str := null;
8922: l_temp_str := fnd_message.get;
8923: l_document := l_document || l_temp_str ||TAB||TAB||l_bill_to_address||NEWLINE;
8924:
8925: fnd_message.set_name('IBE','IBE_PRMT_CITY_COLON');
8926: l_temp_str := null;

Line 8925: fnd_message.set_name('IBE','IBE_PRMT_CITY_COLON');

8921: l_temp_str := null;
8922: l_temp_str := fnd_message.get;
8923: l_document := l_document || l_temp_str ||TAB||TAB||l_bill_to_address||NEWLINE;
8924:
8925: fnd_message.set_name('IBE','IBE_PRMT_CITY_COLON');
8926: l_temp_str := null;
8927: l_temp_str := fnd_message.get;
8928: l_document := l_document || l_temp_str ||TAB||TAB||TAB||l_bill_to_city||NEWLINE;
8929:

Line 8927: l_temp_str := fnd_message.get;

8923: l_document := l_document || l_temp_str ||TAB||TAB||l_bill_to_address||NEWLINE;
8924:
8925: fnd_message.set_name('IBE','IBE_PRMT_CITY_COLON');
8926: l_temp_str := null;
8927: l_temp_str := fnd_message.get;
8928: l_document := l_document || l_temp_str ||TAB||TAB||TAB||l_bill_to_city||NEWLINE;
8929:
8930: fnd_message.set_name('IBE','IBE_PRMT_STATE_PRO_COLON');
8931: l_temp_str := null;

Line 8930: fnd_message.set_name('IBE','IBE_PRMT_STATE_PRO_COLON');

8926: l_temp_str := null;
8927: l_temp_str := fnd_message.get;
8928: l_document := l_document || l_temp_str ||TAB||TAB||TAB||l_bill_to_city||NEWLINE;
8929:
8930: fnd_message.set_name('IBE','IBE_PRMT_STATE_PRO_COLON');
8931: l_temp_str := null;
8932: l_temp_str := fnd_message.get;
8933: l_document := l_document || l_temp_str ||TAB||TAB||l_bill_to_state||NEWLINE;
8934:

Line 8932: l_temp_str := fnd_message.get;

8928: l_document := l_document || l_temp_str ||TAB||TAB||TAB||l_bill_to_city||NEWLINE;
8929:
8930: fnd_message.set_name('IBE','IBE_PRMT_STATE_PRO_COLON');
8931: l_temp_str := null;
8932: l_temp_str := fnd_message.get;
8933: l_document := l_document || l_temp_str ||TAB||TAB||l_bill_to_state||NEWLINE;
8934:
8935: fnd_message.set_name('IBE','IBE_PRMT_ZIP_POSTAL_COLON');
8936: l_temp_str := null;

Line 8935: fnd_message.set_name('IBE','IBE_PRMT_ZIP_POSTAL_COLON');

8931: l_temp_str := null;
8932: l_temp_str := fnd_message.get;
8933: l_document := l_document || l_temp_str ||TAB||TAB||l_bill_to_state||NEWLINE;
8934:
8935: fnd_message.set_name('IBE','IBE_PRMT_ZIP_POSTAL_COLON');
8936: l_temp_str := null;
8937: l_temp_str := fnd_message.get;
8938: l_document := l_document || l_temp_str ||TAB||l_bill_to_zip||NEWLINE;
8939:

Line 8937: l_temp_str := fnd_message.get;

8933: l_document := l_document || l_temp_str ||TAB||TAB||l_bill_to_state||NEWLINE;
8934:
8935: fnd_message.set_name('IBE','IBE_PRMT_ZIP_POSTAL_COLON');
8936: l_temp_str := null;
8937: l_temp_str := fnd_message.get;
8938: l_document := l_document || l_temp_str ||TAB||l_bill_to_zip||NEWLINE;
8939:
8940: fnd_message.set_name('IBE','IBE_PRMT_COUNTRY_COLON');
8941: l_temp_str := null;

Line 8940: fnd_message.set_name('IBE','IBE_PRMT_COUNTRY_COLON');

8936: l_temp_str := null;
8937: l_temp_str := fnd_message.get;
8938: l_document := l_document || l_temp_str ||TAB||l_bill_to_zip||NEWLINE;
8939:
8940: fnd_message.set_name('IBE','IBE_PRMT_COUNTRY_COLON');
8941: l_temp_str := null;
8942: l_temp_str := fnd_message.get;
8943: l_document := l_document || l_temp_str ||TAB||TAB||l_bill_to_country||NEWLINE;
8944:

Line 8942: l_temp_str := fnd_message.get;

8938: l_document := l_document || l_temp_str ||TAB||l_bill_to_zip||NEWLINE;
8939:
8940: fnd_message.set_name('IBE','IBE_PRMT_COUNTRY_COLON');
8941: l_temp_str := null;
8942: l_temp_str := fnd_message.get;
8943: l_document := l_document || l_temp_str ||TAB||TAB||l_bill_to_country||NEWLINE;
8944:
8945: fnd_message.set_name('IBE','IBE_PRMT_CNTCT_NAME_COL');
8946: l_temp_str := null;

Line 8945: fnd_message.set_name('IBE','IBE_PRMT_CNTCT_NAME_COL');

8941: l_temp_str := null;
8942: l_temp_str := fnd_message.get;
8943: l_document := l_document || l_temp_str ||TAB||TAB||l_bill_to_country||NEWLINE;
8944:
8945: fnd_message.set_name('IBE','IBE_PRMT_CNTCT_NAME_COL');
8946: l_temp_str := null;
8947: l_temp_str := fnd_message.get;
8948: l_document := l_document || l_temp_str ||TAB||TAB||l_bill_to_name||NEWLINE;
8949:

Line 8947: l_temp_str := fnd_message.get;

8943: l_document := l_document || l_temp_str ||TAB||TAB||l_bill_to_country||NEWLINE;
8944:
8945: fnd_message.set_name('IBE','IBE_PRMT_CNTCT_NAME_COL');
8946: l_temp_str := null;
8947: l_temp_str := fnd_message.get;
8948: l_document := l_document || l_temp_str ||TAB||TAB||l_bill_to_name||NEWLINE;
8949:
8950: fnd_message.set_name('IBE','IBE_PRMT_TEL_NO_COLON');
8951: l_temp_str := null;

Line 8950: fnd_message.set_name('IBE','IBE_PRMT_TEL_NO_COLON');

8946: l_temp_str := null;
8947: l_temp_str := fnd_message.get;
8948: l_document := l_document || l_temp_str ||TAB||TAB||l_bill_to_name||NEWLINE;
8949:
8950: fnd_message.set_name('IBE','IBE_PRMT_TEL_NO_COLON');
8951: l_temp_str := null;
8952: l_temp_str := fnd_message.get;
8953: l_document := l_document || l_temp_str ||TAB||l_bill_to_number||NEWLINE;
8954:

Line 8952: l_temp_str := fnd_message.get;

8948: l_document := l_document || l_temp_str ||TAB||TAB||l_bill_to_name||NEWLINE;
8949:
8950: fnd_message.set_name('IBE','IBE_PRMT_TEL_NO_COLON');
8951: l_temp_str := null;
8952: l_temp_str := fnd_message.get;
8953: l_document := l_document || l_temp_str ||TAB||l_bill_to_number||NEWLINE;
8954:
8955: fnd_message.set_name('IBE','IBE_PRMT_FAX_NO_COLON');
8956: l_temp_str := null;

Line 8955: fnd_message.set_name('IBE','IBE_PRMT_FAX_NO_COLON');

8951: l_temp_str := null;
8952: l_temp_str := fnd_message.get;
8953: l_document := l_document || l_temp_str ||TAB||l_bill_to_number||NEWLINE;
8954:
8955: fnd_message.set_name('IBE','IBE_PRMT_FAX_NO_COLON');
8956: l_temp_str := null;
8957: l_temp_str := fnd_message.get;
8958: l_document := l_document || l_temp_str ||TAB||TAB||l_bill_to_fax||NEWLINE;
8959:

Line 8957: l_temp_str := fnd_message.get;

8953: l_document := l_document || l_temp_str ||TAB||l_bill_to_number||NEWLINE;
8954:
8955: fnd_message.set_name('IBE','IBE_PRMT_FAX_NO_COLON');
8956: l_temp_str := null;
8957: l_temp_str := fnd_message.get;
8958: l_document := l_document || l_temp_str ||TAB||TAB||l_bill_to_fax||NEWLINE;
8959:
8960: fnd_message.set_name('IBE','IBE_PRMT_ORD_SHIP_INFOR');
8961: l_temp_str := null;

Line 8960: fnd_message.set_name('IBE','IBE_PRMT_ORD_SHIP_INFOR');

8956: l_temp_str := null;
8957: l_temp_str := fnd_message.get;
8958: l_document := l_document || l_temp_str ||TAB||TAB||l_bill_to_fax||NEWLINE;
8959:
8960: fnd_message.set_name('IBE','IBE_PRMT_ORD_SHIP_INFOR');
8961: l_temp_str := null;
8962: l_temp_str := fnd_message.get;
8963: l_document := l_document || NEWLINE ||l_temp_str ||NEWLINE||NEWLINE;
8964:

Line 8962: l_temp_str := fnd_message.get;

8958: l_document := l_document || l_temp_str ||TAB||TAB||l_bill_to_fax||NEWLINE;
8959:
8960: fnd_message.set_name('IBE','IBE_PRMT_ORD_SHIP_INFOR');
8961: l_temp_str := null;
8962: l_temp_str := fnd_message.get;
8963: l_document := l_document || NEWLINE ||l_temp_str ||NEWLINE||NEWLINE;
8964:
8965: fnd_message.set_name('IBE','IBE_PRMT_CUST_NAME_COLON');
8966: l_temp_str := null;

Line 8965: fnd_message.set_name('IBE','IBE_PRMT_CUST_NAME_COLON');

8961: l_temp_str := null;
8962: l_temp_str := fnd_message.get;
8963: l_document := l_document || NEWLINE ||l_temp_str ||NEWLINE||NEWLINE;
8964:
8965: fnd_message.set_name('IBE','IBE_PRMT_CUST_NAME_COLON');
8966: l_temp_str := null;
8967: l_temp_str := fnd_message.get;
8968: l_document := l_document || l_temp_str ||TAB||TAB||l_ship_to_party_name||NEWLINE;
8969:

Line 8967: l_temp_str := fnd_message.get;

8963: l_document := l_document || NEWLINE ||l_temp_str ||NEWLINE||NEWLINE;
8964:
8965: fnd_message.set_name('IBE','IBE_PRMT_CUST_NAME_COLON');
8966: l_temp_str := null;
8967: l_temp_str := fnd_message.get;
8968: l_document := l_document || l_temp_str ||TAB||TAB||l_ship_to_party_name||NEWLINE;
8969:
8970: fnd_message.set_name('IBE','IBE_PRMT_ADDRESS_COLON');
8971: l_temp_str := null;

Line 8970: fnd_message.set_name('IBE','IBE_PRMT_ADDRESS_COLON');

8966: l_temp_str := null;
8967: l_temp_str := fnd_message.get;
8968: l_document := l_document || l_temp_str ||TAB||TAB||l_ship_to_party_name||NEWLINE;
8969:
8970: fnd_message.set_name('IBE','IBE_PRMT_ADDRESS_COLON');
8971: l_temp_str := null;
8972: l_temp_str := fnd_message.get;
8973: l_document := l_document || l_temp_str ||TAB||TAB||l_ship_to_address||NEWLINE;
8974:

Line 8972: l_temp_str := fnd_message.get;

8968: l_document := l_document || l_temp_str ||TAB||TAB||l_ship_to_party_name||NEWLINE;
8969:
8970: fnd_message.set_name('IBE','IBE_PRMT_ADDRESS_COLON');
8971: l_temp_str := null;
8972: l_temp_str := fnd_message.get;
8973: l_document := l_document || l_temp_str ||TAB||TAB||l_ship_to_address||NEWLINE;
8974:
8975: fnd_message.set_name('IBE','IBE_PRMT_CITY_COLON');
8976: l_temp_str := null;

Line 8975: fnd_message.set_name('IBE','IBE_PRMT_CITY_COLON');

8971: l_temp_str := null;
8972: l_temp_str := fnd_message.get;
8973: l_document := l_document || l_temp_str ||TAB||TAB||l_ship_to_address||NEWLINE;
8974:
8975: fnd_message.set_name('IBE','IBE_PRMT_CITY_COLON');
8976: l_temp_str := null;
8977: l_temp_str := fnd_message.get;
8978: l_document := l_document || l_temp_str ||TAB||TAB||TAB||l_ship_to_city||NEWLINE;
8979:

Line 8977: l_temp_str := fnd_message.get;

8973: l_document := l_document || l_temp_str ||TAB||TAB||l_ship_to_address||NEWLINE;
8974:
8975: fnd_message.set_name('IBE','IBE_PRMT_CITY_COLON');
8976: l_temp_str := null;
8977: l_temp_str := fnd_message.get;
8978: l_document := l_document || l_temp_str ||TAB||TAB||TAB||l_ship_to_city||NEWLINE;
8979:
8980: fnd_message.set_name('IBE','IBE_PRMT_STATE_PRO_COLON');
8981: l_temp_str := null;

Line 8980: fnd_message.set_name('IBE','IBE_PRMT_STATE_PRO_COLON');

8976: l_temp_str := null;
8977: l_temp_str := fnd_message.get;
8978: l_document := l_document || l_temp_str ||TAB||TAB||TAB||l_ship_to_city||NEWLINE;
8979:
8980: fnd_message.set_name('IBE','IBE_PRMT_STATE_PRO_COLON');
8981: l_temp_str := null;
8982: l_temp_str := fnd_message.get;
8983: l_document := l_document || l_temp_str ||TAB||TAB||l_ship_to_state||NEWLINE;
8984:

Line 8982: l_temp_str := fnd_message.get;

8978: l_document := l_document || l_temp_str ||TAB||TAB||TAB||l_ship_to_city||NEWLINE;
8979:
8980: fnd_message.set_name('IBE','IBE_PRMT_STATE_PRO_COLON');
8981: l_temp_str := null;
8982: l_temp_str := fnd_message.get;
8983: l_document := l_document || l_temp_str ||TAB||TAB||l_ship_to_state||NEWLINE;
8984:
8985: fnd_message.set_name('IBE','IBE_PRMT_COUNTRY_COLON');
8986: l_temp_str := null;

Line 8985: fnd_message.set_name('IBE','IBE_PRMT_COUNTRY_COLON');

8981: l_temp_str := null;
8982: l_temp_str := fnd_message.get;
8983: l_document := l_document || l_temp_str ||TAB||TAB||l_ship_to_state||NEWLINE;
8984:
8985: fnd_message.set_name('IBE','IBE_PRMT_COUNTRY_COLON');
8986: l_temp_str := null;
8987: l_temp_str := fnd_message.get;
8988: l_document := l_document || l_temp_str ||TAB||TAB||l_ship_to_country||NEWLINE;
8989:

Line 8987: l_temp_str := fnd_message.get;

8983: l_document := l_document || l_temp_str ||TAB||TAB||l_ship_to_state||NEWLINE;
8984:
8985: fnd_message.set_name('IBE','IBE_PRMT_COUNTRY_COLON');
8986: l_temp_str := null;
8987: l_temp_str := fnd_message.get;
8988: l_document := l_document || l_temp_str ||TAB||TAB||l_ship_to_country||NEWLINE;
8989:
8990: fnd_message.set_name('IBE','IBE_PRMT_CNTCT_NAME_COL');
8991: l_temp_str := null;

Line 8990: fnd_message.set_name('IBE','IBE_PRMT_CNTCT_NAME_COL');

8986: l_temp_str := null;
8987: l_temp_str := fnd_message.get;
8988: l_document := l_document || l_temp_str ||TAB||TAB||l_ship_to_country||NEWLINE;
8989:
8990: fnd_message.set_name('IBE','IBE_PRMT_CNTCT_NAME_COL');
8991: l_temp_str := null;
8992: l_temp_str := fnd_message.get;
8993: l_document := l_document || l_temp_str ||TAB||TAB||l_ship_to_name||NEWLINE;
8994:

Line 8992: l_temp_str := fnd_message.get;

8988: l_document := l_document || l_temp_str ||TAB||TAB||l_ship_to_country||NEWLINE;
8989:
8990: fnd_message.set_name('IBE','IBE_PRMT_CNTCT_NAME_COL');
8991: l_temp_str := null;
8992: l_temp_str := fnd_message.get;
8993: l_document := l_document || l_temp_str ||TAB||TAB||l_ship_to_name||NEWLINE;
8994:
8995: fnd_message.set_name('IBE','IBE_PRMT_TEL_NO_COLON');
8996: l_temp_str := null;

Line 8995: fnd_message.set_name('IBE','IBE_PRMT_TEL_NO_COLON');

8991: l_temp_str := null;
8992: l_temp_str := fnd_message.get;
8993: l_document := l_document || l_temp_str ||TAB||TAB||l_ship_to_name||NEWLINE;
8994:
8995: fnd_message.set_name('IBE','IBE_PRMT_TEL_NO_COLON');
8996: l_temp_str := null;
8997: l_temp_str := fnd_message.get;
8998: l_document := l_document || l_temp_str ||TAB||l_ship_to_number||NEWLINE;
8999:

Line 8997: l_temp_str := fnd_message.get;

8993: l_document := l_document || l_temp_str ||TAB||TAB||l_ship_to_name||NEWLINE;
8994:
8995: fnd_message.set_name('IBE','IBE_PRMT_TEL_NO_COLON');
8996: l_temp_str := null;
8997: l_temp_str := fnd_message.get;
8998: l_document := l_document || l_temp_str ||TAB||l_ship_to_number||NEWLINE;
8999:
9000: fnd_message.set_name('IBE','IBE_PRMT_FAX_NO_COLON');
9001: l_temp_str := null;

Line 9000: fnd_message.set_name('IBE','IBE_PRMT_FAX_NO_COLON');

8996: l_temp_str := null;
8997: l_temp_str := fnd_message.get;
8998: l_document := l_document || l_temp_str ||TAB||l_ship_to_number||NEWLINE;
8999:
9000: fnd_message.set_name('IBE','IBE_PRMT_FAX_NO_COLON');
9001: l_temp_str := null;
9002: l_temp_str := fnd_message.get;
9003: l_document := l_document || l_temp_str ||TAB||TAB||l_ship_to_fax||NEWLINE;
9004:

Line 9002: l_temp_str := fnd_message.get;

8998: l_document := l_document || l_temp_str ||TAB||l_ship_to_number||NEWLINE;
8999:
9000: fnd_message.set_name('IBE','IBE_PRMT_FAX_NO_COLON');
9001: l_temp_str := null;
9002: l_temp_str := fnd_message.get;
9003: l_document := l_document || l_temp_str ||TAB||TAB||l_ship_to_fax||NEWLINE;
9004:
9005: --ELSE
9006: --null;

Line 9280: fnd_message.set_name('IBE','IBE_PRMT_OT_ONE_TIME_PRICE');

9276: For curr_sym_rec In c_curr_symbol(g_quote_header_rec.Currency_code) Loop
9277: l_curr_sym := trim(curr_sym_rec.symbol);
9278: End Loop;
9279:
9280: fnd_message.set_name('IBE','IBE_PRMT_OT_ONE_TIME_PRICE');
9281: l_temp_str := null;
9282: l_temp_str := fnd_message.get;
9283: l_can_amt := ibe_util.nls_number_format(p_number_in => to_char(g_quote_header_rec.total_quote_price));
9284: l_document := l_document|| lpad(l_temp_str,51,' ')|| ' '|| lpad(l_curr_sym||to_char(to_number(l_can_amt), l_amt_format), 20, ' ')||NEWLINE;

Line 9282: l_temp_str := fnd_message.get;

9278: End Loop;
9279:
9280: fnd_message.set_name('IBE','IBE_PRMT_OT_ONE_TIME_PRICE');
9281: l_temp_str := null;
9282: l_temp_str := fnd_message.get;
9283: l_can_amt := ibe_util.nls_number_format(p_number_in => to_char(g_quote_header_rec.total_quote_price));
9284: l_document := l_document|| lpad(l_temp_str,51,' ')|| ' '|| lpad(l_curr_sym||to_char(to_number(l_can_amt), l_amt_format), 20, ' ')||NEWLINE;
9285:
9286: OPEN c_reccur_quote_footer(l_quote_id);

Line 9324: fnd_message.set_name('IBE','IBE_PRMT_SUBTOTAL_COLON');

9320:
9321: --IF (display_type = 'text/plain' ) THEN
9322: IF l_view_net_price_flag = 'Y' THEN
9323:
9324: fnd_message.set_name('IBE','IBE_PRMT_SUBTOTAL_COLON');
9325: l_temp_str := null;
9326: l_temp_str := fnd_message.get;
9327:
9328: l_sub_total := g_quote_header_rec.total_list_price - abs(g_quote_header_rec.total_adjusted_amount);

Line 9326: l_temp_str := fnd_message.get;

9322: IF l_view_net_price_flag = 'Y' THEN
9323:
9324: fnd_message.set_name('IBE','IBE_PRMT_SUBTOTAL_COLON');
9325: l_temp_str := null;
9326: l_temp_str := fnd_message.get;
9327:
9328: l_sub_total := g_quote_header_rec.total_list_price - abs(g_quote_header_rec.total_adjusted_amount);
9329: l_can_amt := ibe_util.nls_number_format(p_number_in => to_char(l_sub_total));
9330: l_document := l_document || lpad(l_temp_str,51,' ')|| ' '|| lpad( l_curr_sym||to_char(to_number(l_can_amt),l_amt_format), 20, ' ')|| NEWLINE;

Line 9333: fnd_message.set_name('IBE','IBE_PRMT_SHIP_HAND_COLON');

9329: l_can_amt := ibe_util.nls_number_format(p_number_in => to_char(l_sub_total));
9330: l_document := l_document || lpad(l_temp_str,51,' ')|| ' '|| lpad( l_curr_sym||to_char(to_number(l_can_amt),l_amt_format), 20, ' ')|| NEWLINE;
9331:
9332:
9333: fnd_message.set_name('IBE','IBE_PRMT_SHIP_HAND_COLON');
9334: l_temp_str := null;
9335: l_temp_str := fnd_message.get;
9336: l_can_amt := ibe_util.nls_number_format(p_number_in => to_char(g_quote_header_rec.total_shipping_charge));
9337: l_document := l_document || lpad(l_temp_str,51,' ')|| ' '|| lpad(l_curr_sym||to_char(to_number(l_can_amt), l_amt_format), 20, ' ')|| NEWLINE;

Line 9335: l_temp_str := fnd_message.get;

9331:
9332:
9333: fnd_message.set_name('IBE','IBE_PRMT_SHIP_HAND_COLON');
9334: l_temp_str := null;
9335: l_temp_str := fnd_message.get;
9336: l_can_amt := ibe_util.nls_number_format(p_number_in => to_char(g_quote_header_rec.total_shipping_charge));
9337: l_document := l_document || lpad(l_temp_str,51,' ')|| ' '|| lpad(l_curr_sym||to_char(to_number(l_can_amt), l_amt_format), 20, ' ')|| NEWLINE;
9338:
9339:

Line 9340: fnd_message.set_name('IBE','IBE_PRMT_TAX_EST_COLON');

9336: l_can_amt := ibe_util.nls_number_format(p_number_in => to_char(g_quote_header_rec.total_shipping_charge));
9337: l_document := l_document || lpad(l_temp_str,51,' ')|| ' '|| lpad(l_curr_sym||to_char(to_number(l_can_amt), l_amt_format), 20, ' ')|| NEWLINE;
9338:
9339:
9340: fnd_message.set_name('IBE','IBE_PRMT_TAX_EST_COLON');
9341: l_temp_str := null;
9342: l_temp_str := fnd_message.get;
9343: l_can_amt := ibe_util.nls_number_format(p_number_in => to_char(g_quote_header_rec.total_tax));
9344: l_document := l_document || lpad(l_temp_str,51,' ')|| ' '|| lpad(l_curr_sym||to_char(to_number(l_can_amt),l_amt_format),20,' ')|| NEWLINE;

Line 9342: l_temp_str := fnd_message.get;

9338:
9339:
9340: fnd_message.set_name('IBE','IBE_PRMT_TAX_EST_COLON');
9341: l_temp_str := null;
9342: l_temp_str := fnd_message.get;
9343: l_can_amt := ibe_util.nls_number_format(p_number_in => to_char(g_quote_header_rec.total_tax));
9344: l_document := l_document || lpad(l_temp_str,51,' ')|| ' '|| lpad(l_curr_sym||to_char(to_number(l_can_amt),l_amt_format),20,' ')|| NEWLINE;
9345:
9346: fnd_message.set_name('IBE','IBE_PRMT_SC_TOTAL2');

Line 9346: fnd_message.set_name('IBE','IBE_PRMT_SC_TOTAL2');

9342: l_temp_str := fnd_message.get;
9343: l_can_amt := ibe_util.nls_number_format(p_number_in => to_char(g_quote_header_rec.total_tax));
9344: l_document := l_document || lpad(l_temp_str,51,' ')|| ' '|| lpad(l_curr_sym||to_char(to_number(l_can_amt),l_amt_format),20,' ')|| NEWLINE;
9345:
9346: fnd_message.set_name('IBE','IBE_PRMT_SC_TOTAL2');
9347: l_temp_str := null;
9348: l_temp_str := fnd_message.get;
9349: l_can_amt := ibe_util.nls_number_format(p_number_in => to_char(g_quote_header_rec.total_quote_price));
9350: l_document := l_document || lpad(l_temp_str,51,' ')|| ' '|| lpad(l_curr_sym|| to_char(to_number(l_can_amt),l_amt_format),20,' ');

Line 9348: l_temp_str := fnd_message.get;

9344: l_document := l_document || lpad(l_temp_str,51,' ')|| ' '|| lpad(l_curr_sym||to_char(to_number(l_can_amt),l_amt_format),20,' ')|| NEWLINE;
9345:
9346: fnd_message.set_name('IBE','IBE_PRMT_SC_TOTAL2');
9347: l_temp_str := null;
9348: l_temp_str := fnd_message.get;
9349: l_can_amt := ibe_util.nls_number_format(p_number_in => to_char(g_quote_header_rec.total_quote_price));
9350: l_document := l_document || lpad(l_temp_str,51,' ')|| ' '|| lpad(l_curr_sym|| to_char(to_number(l_can_amt),l_amt_format),20,' ');
9351: END IF;
9352: --ELSE

Line 9372: fnd_message.set_name('IBE','IBE_PRMT_SC_PAY_NOW_CHARGES');

9368: l_curr_sym := trim(curr_sym_rec.symbol);
9369: End Loop;
9370: END IF;
9371: IF l_view_net_price_flag = 'Y' THEN
9372: fnd_message.set_name('IBE','IBE_PRMT_SC_PAY_NOW_CHARGES');
9373: l_temp_str := null;
9374: l_temp_str := fnd_message.get;
9375: l_document := l_document || lpad(l_temp_str,51,' ')||NEWLINE;
9376: l_document := l_document || lpad('-',(51-length(l_temp_str)))||rpad('-',(71-(51-(length(l_temp_str)))),'-')||NEWLINE;

Line 9374: l_temp_str := fnd_message.get;

9370: END IF;
9371: IF l_view_net_price_flag = 'Y' THEN
9372: fnd_message.set_name('IBE','IBE_PRMT_SC_PAY_NOW_CHARGES');
9373: l_temp_str := null;
9374: l_temp_str := fnd_message.get;
9375: l_document := l_document || lpad(l_temp_str,51,' ')||NEWLINE;
9376: l_document := l_document || lpad('-',(51-length(l_temp_str)))||rpad('-',(71-(51-(length(l_temp_str)))),'-')||NEWLINE;
9377:
9378: fnd_message.set_name('IBE','IBE_PRMT_SUBTOTAL_COLON');

Line 9378: fnd_message.set_name('IBE','IBE_PRMT_SUBTOTAL_COLON');

9374: l_temp_str := fnd_message.get;
9375: l_document := l_document || lpad(l_temp_str,51,' ')||NEWLINE;
9376: l_document := l_document || lpad('-',(51-length(l_temp_str)))||rpad('-',(71-(51-(length(l_temp_str)))),'-')||NEWLINE;
9377:
9378: fnd_message.set_name('IBE','IBE_PRMT_SUBTOTAL_COLON');
9379: l_temp_str := null;
9380: l_temp_str := fnd_message.get;
9381: l_can_amt := ibe_util.nls_number_format(p_number_in => to_char(g_macd_quote_rec.paynow_lines_total));
9382: l_document := l_document ||lpad(l_temp_str,51,' ')||' '|| lpad(l_curr_sym||to_char(to_number(l_can_amt),l_amt_format),20,' ')||NEWLINE;

Line 9380: l_temp_str := fnd_message.get;

9376: l_document := l_document || lpad('-',(51-length(l_temp_str)))||rpad('-',(71-(51-(length(l_temp_str)))),'-')||NEWLINE;
9377:
9378: fnd_message.set_name('IBE','IBE_PRMT_SUBTOTAL_COLON');
9379: l_temp_str := null;
9380: l_temp_str := fnd_message.get;
9381: l_can_amt := ibe_util.nls_number_format(p_number_in => to_char(g_macd_quote_rec.paynow_lines_total));
9382: l_document := l_document ||lpad(l_temp_str,51,' ')||' '|| lpad(l_curr_sym||to_char(to_number(l_can_amt),l_amt_format),20,' ')||NEWLINE;
9383:
9384: fnd_message.set_name('IBE','IBE_PRMT_TAX_COL');

Line 9384: fnd_message.set_name('IBE','IBE_PRMT_TAX_COL');

9380: l_temp_str := fnd_message.get;
9381: l_can_amt := ibe_util.nls_number_format(p_number_in => to_char(g_macd_quote_rec.paynow_lines_total));
9382: l_document := l_document ||lpad(l_temp_str,51,' ')||' '|| lpad(l_curr_sym||to_char(to_number(l_can_amt),l_amt_format),20,' ')||NEWLINE;
9383:
9384: fnd_message.set_name('IBE','IBE_PRMT_TAX_COL');
9385: l_temp_str := null;
9386: l_temp_str := fnd_message.get;
9387: l_can_amt := ibe_util.nls_number_format(p_number_in => to_char(g_macd_quote_rec.paynow_taxes_total));
9388: l_document := l_document || lpad(l_temp_str,51,' ')||' '|| lpad(l_curr_sym||to_char(to_number(l_can_amt),l_amt_format),20,' ')||NEWLINE;

Line 9386: l_temp_str := fnd_message.get;

9382: l_document := l_document ||lpad(l_temp_str,51,' ')||' '|| lpad(l_curr_sym||to_char(to_number(l_can_amt),l_amt_format),20,' ')||NEWLINE;
9383:
9384: fnd_message.set_name('IBE','IBE_PRMT_TAX_COL');
9385: l_temp_str := null;
9386: l_temp_str := fnd_message.get;
9387: l_can_amt := ibe_util.nls_number_format(p_number_in => to_char(g_macd_quote_rec.paynow_taxes_total));
9388: l_document := l_document || lpad(l_temp_str,51,' ')||' '|| lpad(l_curr_sym||to_char(to_number(l_can_amt),l_amt_format),20,' ')||NEWLINE;
9389:
9390: fnd_message.set_name('IBE','IBE_PRMT_SHIP_HAND_COLON');

Line 9390: fnd_message.set_name('IBE','IBE_PRMT_SHIP_HAND_COLON');

9386: l_temp_str := fnd_message.get;
9387: l_can_amt := ibe_util.nls_number_format(p_number_in => to_char(g_macd_quote_rec.paynow_taxes_total));
9388: l_document := l_document || lpad(l_temp_str,51,' ')||' '|| lpad(l_curr_sym||to_char(to_number(l_can_amt),l_amt_format),20,' ')||NEWLINE;
9389:
9390: fnd_message.set_name('IBE','IBE_PRMT_SHIP_HAND_COLON');
9391: l_temp_str := null;
9392: l_temp_str := fnd_message.get;
9393: l_can_amt := ibe_util.nls_number_format(p_number_in => to_char(g_macd_quote_rec.paynow_charges_total));
9394: l_document := l_document || lpad(l_temp_str,51,' ')||' '|| lpad(l_curr_sym||to_char(to_number(l_can_amt),l_amt_format),20,' ')||NEWLINE;

Line 9392: l_temp_str := fnd_message.get;

9388: l_document := l_document || lpad(l_temp_str,51,' ')||' '|| lpad(l_curr_sym||to_char(to_number(l_can_amt),l_amt_format),20,' ')||NEWLINE;
9389:
9390: fnd_message.set_name('IBE','IBE_PRMT_SHIP_HAND_COLON');
9391: l_temp_str := null;
9392: l_temp_str := fnd_message.get;
9393: l_can_amt := ibe_util.nls_number_format(p_number_in => to_char(g_macd_quote_rec.paynow_charges_total));
9394: l_document := l_document || lpad(l_temp_str,51,' ')||' '|| lpad(l_curr_sym||to_char(to_number(l_can_amt),l_amt_format),20,' ')||NEWLINE;
9395:
9396: fnd_message.set_name('IBE','IBE_PRMT_SC_PN_TOTAL_COL');

Line 9396: fnd_message.set_name('IBE','IBE_PRMT_SC_PN_TOTAL_COL');

9392: l_temp_str := fnd_message.get;
9393: l_can_amt := ibe_util.nls_number_format(p_number_in => to_char(g_macd_quote_rec.paynow_charges_total));
9394: l_document := l_document || lpad(l_temp_str,51,' ')||' '|| lpad(l_curr_sym||to_char(to_number(l_can_amt),l_amt_format),20,' ')||NEWLINE;
9395:
9396: fnd_message.set_name('IBE','IBE_PRMT_SC_PN_TOTAL_COL');
9397: l_temp_str := null;
9398: l_temp_str := fnd_message.get;
9399: l_can_amt := ibe_util.nls_number_format(p_number_in => to_char(g_macd_quote_rec.paynow_order_total));
9400: l_document := l_document|| lpad(l_temp_str,51,' ')|| ' '|| lpad(l_curr_sym||to_char(to_number(l_can_amt), l_amt_format), 20, ' ');

Line 9398: l_temp_str := fnd_message.get;

9394: l_document := l_document || lpad(l_temp_str,51,' ')||' '|| lpad(l_curr_sym||to_char(to_number(l_can_amt),l_amt_format),20,' ')||NEWLINE;
9395:
9396: fnd_message.set_name('IBE','IBE_PRMT_SC_PN_TOTAL_COL');
9397: l_temp_str := null;
9398: l_temp_str := fnd_message.get;
9399: l_can_amt := ibe_util.nls_number_format(p_number_in => to_char(g_macd_quote_rec.paynow_order_total));
9400: l_document := l_document|| lpad(l_temp_str,51,' ')|| ' '|| lpad(l_curr_sym||to_char(to_number(l_can_amt), l_amt_format), 20, ' ');
9401: END IF;
9402: END LOOP;

Line 10072: PROCEDURE get_FND_message(

10068: document_type := 'text/plain';
10069: END IF;
10070: END ;
10071:
10072: PROCEDURE get_FND_message(
10073: document_id IN VARCHAR2,
10074: display_type IN VARCHAR2,
10075: document IN OUT NOCOPY VARCHAR2,
10076: document_type IN OUT NOCOPY VARCHAR2

Line 10081: IBE_UTIL.DEBUG('get_FND_message:START: value of document id ='||document_id);

10077: ) is
10078:
10079: BEGIN
10080: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
10081: IBE_UTIL.DEBUG('get_FND_message:START: value of document id ='||document_id);
10082: END IF;
10083: FND_MESSAGE.set_name('IBE',document_id);
10084: document:=FND_MESSAGE.get();
10085:

Line 10083: FND_MESSAGE.set_name('IBE',document_id);

10079: BEGIN
10080: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
10081: IBE_UTIL.DEBUG('get_FND_message:START: value of document id ='||document_id);
10082: END IF;
10083: FND_MESSAGE.set_name('IBE',document_id);
10084: document:=FND_MESSAGE.get();
10085:
10086: IF(display_type = 'text/html') THEN
10087: document_type := 'text/html';

Line 10084: document:=FND_MESSAGE.get();

10080: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
10081: IBE_UTIL.DEBUG('get_FND_message:START: value of document id ='||document_id);
10082: END IF;
10083: FND_MESSAGE.set_name('IBE',document_id);
10084: document:=FND_MESSAGE.get();
10085:
10086: IF(display_type = 'text/html') THEN
10087: document_type := 'text/html';
10088: ELSE

Line 10092: END get_FND_message;

10088: ELSE
10089: document_type := 'text/plain';
10090: END IF;
10091:
10092: END get_FND_message;
10093:
10094: PROCEDURE get_date(
10095: document_id IN VARCHAR2,
10096: display_type IN VARCHAR2,

Line 10230: fnd_message.set_name('IBE','IBE_PRMT_ORD_TAX');

10226: l_string_in := l_string_left;
10227: END LOOP;
10228: IF(tax_flag = fnd_api.g_true) then
10229: IF view_net_price_flag = 'Y' THEN
10230: fnd_message.set_name('IBE','IBE_PRMT_ORD_TAX');
10231: l_temp_str := null;
10232: l_temp_str := fnd_message.get;
10233: l_can_amt := ibe_util.nls_number_format(p_number_in => to_char(Notif_Line_Tbl(counter).TaxAmount));
10234: ldocument := ldocument ||lpad(l_temp_str||': '||l_curr_sym||to_char(to_number(l_can_amt),l_amt_format),72,' ')||NEWLINE;

Line 10232: l_temp_str := fnd_message.get;

10228: IF(tax_flag = fnd_api.g_true) then
10229: IF view_net_price_flag = 'Y' THEN
10230: fnd_message.set_name('IBE','IBE_PRMT_ORD_TAX');
10231: l_temp_str := null;
10232: l_temp_str := fnd_message.get;
10233: l_can_amt := ibe_util.nls_number_format(p_number_in => to_char(Notif_Line_Tbl(counter).TaxAmount));
10234: ldocument := ldocument ||lpad(l_temp_str||': '||l_curr_sym||to_char(to_number(l_can_amt),l_amt_format),72,' ')||NEWLINE;
10235: END IF;
10236: END IF;